C
crtopher
I am using this code in a query field in design view:
expr1: DLookup("TimeItemNo","lkupTime","TimeDesc=" &
DateDiff("n",[StartTime],[FinishTime]))
to pull up a code number (timeItemNo) that matches a certain period of
elapsed time in minutes but i am getting the error message:
syntax error (missing operator) in query expression 'TimeDesc = '.
followed by:
unknown
the timeItemNo and TimeDesc fields are numbers as is, I imagine, the result
of the DateDiff calculation. The expression worked exactly as typed when used
on a form.
Any help much appreciated!
expr1: DLookup("TimeItemNo","lkupTime","TimeDesc=" &
DateDiff("n",[StartTime],[FinishTime]))
to pull up a code number (timeItemNo) that matches a certain period of
elapsed time in minutes but i am getting the error message:
syntax error (missing operator) in query expression 'TimeDesc = '.
followed by:
unknown
the timeItemNo and TimeDesc fields are numbers as is, I imagine, the result
of the DateDiff calculation. The expression worked exactly as typed when used
on a form.
Any help much appreciated!