Dlookup and Groupby problem (1 Viewer)

[AnnPhil]

I have a groupby query that i use to group by visitID and then max the Visit date so that i can have the last visit date for each customer.

I have a form that list customer information and has a DLookup field that should lookup the last visit date for each customerid. I am getting null values and i know when i run the query there is data. Anyone know why this is not working? Does it have anything to do with the fact that it is based on a groupby query? Any suggestion on a work around?

here is an example of my lookup

=DLookUp("[LastVisitDate]","[qryDateOfLastVisit]","[CustomerID]=[CustomerID]")

 

[pbaldy]

Presuming customer ID is a number, try:

=DLookUp("[LastVisitDate]","[qryDateOfLastVisit]","[CustomerID]= " & [CustomerID])

 

[AnnPhil]

customerID is a text field but i tried your suggestion anyway and it returned me this #Error in the fields.

 

[pbaldy]

If it's a text field, try:

=DLookUp("[LastVisitDate]","[qryDateOfLastVisit]","[CustomerID]= '" & [CustomerID] & "'")

 

[R6Flyer]

If it's a text field, try:

=DLookUp("[LastVisitDate]","[qryDateOfLastVisit]","[CustomerID]= '" & [CustomerID] & "'")

AnnPhil,

Try:

=DLookUp("[LastVisitDate]","qryDateOfLastVisit","[CustomerID]=[CustomerID]")

 

[GrahamB]

Try this

=DLookUp("[LastVisitDate]","[qryDateOfLastVisit]","[CustomerID]=Form.[CustomerID]")

 

[Pat Hartman]

pbaldy's suggestion is the correct solution. You need to enclose the string variable with quotes.