Viewing 5 posts - 1 through 5 (of 5 total)
I thought of that as well Ian. Thanks for that though. The problem on that is that the owner of the queries is only familiar with Access, and is an...
March 8, 2006 at 5:01 pm
#625563
Okay, this didn't work out right. Here's why:
This is the "Master" Select Statement that I need to run in the Query editor, Most of this accesses the SQL backend:
March 8, 2006 at 4:22 pm
#625554
Actually, looking at the sample data provided, you do have a couple of identifiers.
Identifier 1) ST, DR, CR, etc...
There are a finite amount of street identifiers, even if you have...
March 6, 2006 at 12:48 pm
#625006
I already responded to Richard directly, and here is a portion of my response.
Corey, I think you might be closer to the solution. I will attempt to recreate the SQL...
March 3, 2006 at 10:12 am
#624667
This isn't exactly the problem.
You see, the Pivot table is connected to an external connection throught the ODBC driver for Access database objects.
The Access Database object has a...
March 2, 2006 at 2:25 pm
#624473