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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
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 |