If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DlookUp Help!!!!!!!!!
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DLookup problem | CindyK | Running & Setting Up Queries | 5 | February 11th, 2005 11:34 AM |
using wildcards in dlookup | Alex | Running & Setting Up Queries | 3 | February 3rd, 2005 04:49 PM |
DLookUp for multiple forms | [email protected] | Using Forms | 4 | January 9th, 2005 10:48 AM |
DLOOKUP in an external Database gives TYPE Mismatch-Error | Reiner Harmgardt | General Discussion | 1 | July 22nd, 2004 09:00 AM |
DLookup Function in Queries | Jim | Running & Setting Up Queries | 1 | June 10th, 2004 07:07 PM |