DlookUp Help!!!!!!!!!

  • Thread starter Thread starter Tim Leach
  • Start date Start date
T

Tim Leach

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
 
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 & "'")
 
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.
 
Back
Top