Using DLookup with multiple criteria

[cratho]

Is it possible to use the DLookup function in a report with more than one criteria? For example, DLookup("[Amount]", "tblSales", "[Year]= 2002 AND [SaleCD]=1"

I keep getting error messages. Thanks!

 

[GHolden]

What error Message are you getting??

There are two ways to write error-free programs; only the third one works.

 

[cratho]

#Error

I just wanted to make sure it is possible before I try to debug it. It is quite possible that I have the syntax wrong.

 

[Beeps]

Couple of observations:

Put both criteria in own quotes like:

DLookup("[Amount]", "tblSales", "[Year]= 2002" AND "[SaleCD]=1"

Add closing parenthesis to entire function like:

DLookup("[Amount]", "tblSales", "[Year]= 2002" AND "[SaleCD]=1&quot

if the year is a string, then you need to add the single quotes:

DLookup("[Amount]", "tblSales", "[Year]= & '2002'" AND "[SaleCD]=1&quot

 

[GHolden]

Yes it is possible.

I would agree with Beeps second point but not the first

eg. this works fine on my db

strDLookUp = DLookup("Name", "tblName", "Age = 10 AND NameID = 7&quot

There are two ways to write error-free programs; only the third one works.

 

[cratho]

Thanks Beeps!