using DlookUp

ICS

Novice
Local time
Yesterday, 21:05
Joined
Dec 8, 2008
Messages
7
Please Help I am new at writing expressions in expression builder ,I have a tab form with 3 tabs I am trying to show the totals of job collected from the tabs at the bottom of the first tab. This is what I wrote and I keep getting an #Error.
=DLookUp("[total Travel Hrs]","Time card extended","[SCNID]=" & nz([id],0))
=DLookup(“[Field in Query]”,”[Query]”,”[Field in Query]=”&nz([local ID],0))
Thanks
 
It appears your "where" criteria is not pointing to the form control.

Try your access help and search on DLookup. You should see an example of referring to a form control. Form Tab control may be a little different but your code doesn't appear to referr to the form at all.
 
Attached "Cheat Sheet" may assist. I think it is from PBaldy :confused:
Has been a big help to me.
 

Attachments

Users who are viewing this thread

Back
Top Bottom