hi,
based on what you said, it seems like you just need to
drag that info into your query.
dlookup is real useful for populating a text box on a form
or other areas where you need a single value from a table.
dlookup will only returen a single value.
DLookup("[value]", "table", "criteria")
if your were matching something in a text box...
DLookup("[zipcode]", "tabel2", "[zipcode] = '" & Me!
textbox1 & "'")
-----Original Message-----
If I use a Dlookup Function to pull the dat from a zip
code table that
matches the zip code in the query used for a report.
Table1 Fields
Name, address, zipcode, reportnumber
Table2 fields
zip code, city, state, county, longitude, lattitude,
zipcodetype
The query asks for a reportnumber to be input. Based on
that number I need
the report to show the data from table2 that matches the
zipcode from the
record selected in table2.
I can not figure out how to format the DlookUp phrase.
Please help?
Tim Leach
.
|