|
| 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
May 10th, 2005, 04:24 PM
|
|||
|
|||
DLookup question
For years using Access 97 a DLookup control source for a report has worked
perfectly. However, in Access 2003/2000, it fails, returning a blank or #Error. It is: =DLookUp("[Company Name]","[tblShippers]","[Shipper ID]=[Ship Via]") the [Ship Via] value in the table is present. When I originally began investigating, Access had placed a "|" on each side of [Ship Via] (?). In tblShippers each Company Name has a unique Shipper ID. I have tried everything I know of. Any suggestions appreciated. 
|
|
#2
May 10th, 2005, 05:03 PM
|
|||
|
|||
|
You might need something like this:
=DLookUp("[Company Name]","[tblShippers]","[Shipper ID]= " & [Ship Via]) Good Luck "Ed" wrote in message ... For years using Access 97 a DLookup control source for a report has worked perfectly. However, in Access 2003/2000, it fails, returning a blank or #Error. It is: =DLookUp("[Company Name]","[tblShippers]","[Shipper ID]=[Ship Via]") the [Ship Via] value in the table is present. When I originally began investigating, Access had placed a "|" on each side of [Ship Via] (?). In tblShippers each Company Name has a unique Shipper ID. I have tried everything I know of. Any suggestions appreciated.
|
|
#3
May 10th, 2005, 05:12 PM
|
|||
|
|||
|
That solved it!!!!
Thanks GH, you all are the best!! "GH" wrote in message ... You might need something like this: =DLookUp("[Company Name]","[tblShippers]","[Shipper ID]= " & [Ship Via]) Good Luck "Ed" wrote in message ... For years using Access 97 a DLookup control source for a report has worked perfectly. However, in Access 2003/2000, it fails, returning a blank or #Error. It is: =DLookUp("[Company Name]","[tblShippers]","[Shipper ID]=[Ship Via]") the [Ship Via] value in the table is present. When I originally began investigating, Access had placed a "|" on each side of [Ship Via] (?). In tblShippers each Company Name has a unique Shipper ID. I have tried everything I know of. Any suggestions appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DLookup and Conversion in Report | Tom | Setting Up & Running Reports | 1 | April 2nd, 2005 05:21 AM |
| HELP! I'm really struggling to understand DLookup! | Tony Williams | General Discussion | 0 | February 17th, 2005 01:28 PM |
| DLookup Question | Cherish | Running & Setting Up Queries | 1 | August 23rd, 2004 08:45 PM |
| Word question regarding TOC (newbie question)... | Herman Geerlings | Formatting Long Documents | 4 | June 4th, 2004 03:12 PM |
| Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |
Linear Mode
