Tim
In addition to "anonymous"'s response, consider checking Access HELP on the
topic of DLookup(), for examples that may further clarify how you would use
it.
--
Good luck
Jeff Boyce
Access MVP
"Tim Leach" wrote in 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
|