DLookup question

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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.
 
You might need something like this:
=DLookUp("[Company Name]","[tblShippers]","[Shipper ID]= " & [Ship Via])

Good Luck
 
That solved it!!!!
Thanks GH, you all are the best!!

GH said:
You might need something like this:
=DLookUp("[Company Name]","[tblShippers]","[Shipper ID]= " & [Ship Via])

Good Luck

Ed said:
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.
Click to expand...
Click to expand...
 
Back
Top