Hi again,

My problem is that I have a query from table AAA where I have selected some fields to show me the criteria I want.This it is ok

The table AAA have an ID for any record!
There is a table BBB which has an ID for any record too!

Now, I want for the query with table AAA, to bring a field from table BBB without bring it into query for the records with the same ID

e.g.

TABLE AAA
ID Name Last Name
3 DFDG DSGDS

TABLE BBB
ID CITY STATE
3 HJHJ GGGG

I want:
QUERY
ID Name Last Name STATE
3 DFDG DSGDS GGGG

Just remember without bring the table BBB to the query!


Thank you all!

When you build the query with AAA, instead of bringing in the table BBB put this as the last field.

STATE: DLookUp("[STATE]", "BBB", "[ID] = " & [ID])

However, this will work slower than if you bring in table BBB and join it via ID.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division