Field ID Problem

[MatN]

I have a Query where I am referencing a field called "PickupLocation" in a separate table, however the "PickupLocation" field itself is derived from a separate table ("tblLocation") where there are numerous fields, including "BusinessID", "BusinessName", "FloorSuite", etc. - all fields that make up one "PickupLocation". When I run the Query, I receive only "BusinessID" in the "PickupLocation" field, where I would like the Query to return the whole range of fields contained in the associated record at "tblLocation". Is this possible?

[RedGoneWILD]

if i understand correctly what you want...you have to concatenate the fields

so in design view in the "Field:" section, enter......Pickup Location: BusinessID & BusinessName & FloorSuite

Pickup Location will be what the column is named when you run the query....anything after : will be what is concatenated....if you want to add spaces between them, put & " " & between each field

[MatN]

I think this would work under normal circumstances. However, when I add "tblLocation" to the query, I lose all my records, so it doesn't seem to be running properly.

You see, the original query is based on the table "tblProvTransDeliveries" and searches for records with a null value in the "VendorInvoiceNumber" field. The query works fine at this point, except for the ID values as opposed to the full addresses. Once I add the second table, everything goes sideways ...

[RedGoneWILD]

i think you need to save the first view as a query with all fields included...then try running it on the query you saved

[MatN]

I'm not sure I understand ...

[RedGoneWILD]

it probably has to do with the way they are joined

can u post the db?

[MatN]

[MatN]

[MatN]

In Post #7 is the original query, in Post #8 is what happens when I run that query, and then the same query with the table I want to add, but messes up the query results. Sorry I can't post the whole database, but there are privacy issues.