Thanks, both of you.

@Craig: Having looked at the joys and pains of recursive tables and self-joins, and considering that I know my db has exactly 8 nodes, I feel I would...

Thanks, Grant, am looking into it.

PDXpress looks most promising at first glance.

Craig, many thanks for taking the time to give a detailed reply. Very much appreciated.

1. Access is a pain, but the only reason I chose it is because I was...

Anyone home?

Mike, thanks.

CTEs apparently do not work in Access, I suspect.

The data gets mangled when I paste it here, and I can't attach it in Excel.

One last try:

DEPTNAMENameCHECKTIMECHECKTYPE

AdminSammy02-Dec-10 10:36:310

TechTed02-Dec-10 11:13:570

TechSidney02-Dec-10...

This is how I would have implemented the front-end:

Offer the user auto-complete suggestions by concatenating location text entered so far and retrieving ALL records from db where columns match, to...

I suspect the location data is not strictly required to be in a given format, hence the relaxed design, so just an idea: when designing your reports/queries, why not join...

Thanks, Steve.

Steve Jones - SSC Editor (11/10/2010)

---

1. Your login doesn't have rights to this database for some reason. Do you have an sa/sysadmin level login? How are you doing the...

lax.rawat07 (11/10/2010)

---

i have a result set

LedgerId, ProfitAndLoss

46 -3000.00

49 -7000.00

45 ...

I am truly sorry about resuming this thread which I had hoped was resolved:

Q1. I had about ten small databases to detach from this instance. I managed to detach the...

Wow! I evidently touched a raw nerve with my defence of programmers. But if most of you who objected had scrutinised my defence more carefully, you would have seen that...

Well, we have what Brits would call a jolly nice start to the topic.

You have a very legitimate argument there, Grant, and...

Will do right away. Thanks for all the single-handed help.

I don't know, but because you wondered aloud where it would be installed.

Uninstall from the Add-Remove programs option in control panel. (not the right way, just about the...