Access 2007 Dlookup function

N

nybaseball22

Hello,

I recently upgraded to Access 2007 from 2003. I have found that most
of my DLookup funtions are not working. I had one that looked up
based on info from a subform. An example of the coding is below.
Does anyone know if I need to change this code to work in 2007?

=DLookUp("[Station]","[AutosGasStats1Station]","[CountOfStation] = " &
DMax("[CountOfStation]","AutosGasStats1Station"))

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup in subform (Currency) 1
DMax sorting incorrectly 4
Using Max or DMax in DLookUp criteria? 1
Access 2007 - DLookup Function 1
Correct use of Dlookup? 3
The Infamous DLookup function 3
Dlookup Problem in Access 2007 1
Creating a function? 16

Top