I am appending a query to a table called Hours. I want the field Est_Hours to be populated with the hours difference between StartDate and EndDate. I received helped on here about how to do that, and I was successful.
I am able to append the StartDate and EndDate, but when it comes to the Est_Hours, I get an error.
In the query, for Est_Hours, I have
Est_Hours:DateDiff("h",[StartDate],[EndDate])/3
When I don't append it to the Hours table, the calculation comes out correct, but when I try to append the Est_Hours field, I receive
Sytnax error(comma) in query expression 'Hours.[DateDiff("h",[StartDate],[EndDate])/3]'
Any help is much appreciated.
2007-01-25
05:49:19
·
2 answers
·
asked by
ninapanama
3