Hi All,
I have created a query which totals what has been done in a 24hr period.
To display what has been done across all three shifts, I have used the
following expression:
Shift: IIf(TimeValue([dtctime]) Between #06:00:00# And
#14:00:00#,"Earlies",IIf(TimeValue([dtctime]) Between #14:00:00# And
#22:00:00#,"Lates","Nights"))
If I run the query, it runs fine, however, if I remove one the fields from
the query or try to veiw it in SQL view, I receive an error message stating
"Syntax error (missing operator) in query expression '00:00# And
#14:00:00#,"Earlies",IIf(TimeValue([dtctime]) Between #14:00:00# And
#22:00:00#,"Lates","Nights"))'."
Could anyone explain why it is doing this when it works if I run the
query???
Many thanks in advance,
Mark