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...

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:

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...

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...

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...