james_halliwell
Registered User.
- Local time
- Today, 04:15
- Joined
- Feb 13, 2009
- Messages
- 211
Hi All,
Please could someone help me out with the Date / Time field, I want to create a query that works out the time taken from the log being created to it being completed. I have a table with a field called Date_Returned & Date_Completed I have changed the properties on both to general date
The problem is when i create the query i put in
Log_Number – (Order Ref) – (Number Format)
Date_Returned - (Date ) – (general date format)
Date_Returned - (Long Time ) – (General Date format)
Date_Completed – (Long Time) – (General Date format)
Expr—Date_Completed – Date_Returned
The times all return 00:00:00. Please could someone advise where i am going wrong
Many thanks
Please could someone help me out with the Date / Time field, I want to create a query that works out the time taken from the log being created to it being completed. I have a table with a field called Date_Returned & Date_Completed I have changed the properties on both to general date
The problem is when i create the query i put in
Log_Number – (Order Ref) – (Number Format)
Date_Returned - (Date ) – (general date format)
Date_Returned - (Long Time ) – (General Date format)
Date_Completed – (Long Time) – (General Date format)
Expr—Date_Completed – Date_Returned
The times all return 00:00:00. Please could someone advise where i am going wrong
Many thanks