How do you pull an answer from a Dlookup when the answer is a calculated field?
I have tried to build the formula as if it was looking for a numeric answer:
Code:
DLookup("YTD TOTAL" , "qrySalaries" , "DEPARTMENT= 3200")
And as if it was a text string:
Code:
DLookup("YTD TOTAL" , "qrySalaries" , "DEPARTMENT= '3200'")
I have also tried to use the expression builder to just point to the field in the qry, and I still get an #error message
I should also mention that when I use this exact formula to look for a particular month, say "JANUARY", it pulls the correct number?
Thanks in advance for any help. I should also say that I did a good amount of research before I posted this question, and now I am up against a deadline (unfortunately) and any help would be greatly appreciated,