Hi, i would like to know how to get the time difference between 2 times in Access 2007
i have "Time Out" in one column and "Time In" in other column and "Time Consumed" in other column.
Thanks,
Raaj.
Hi, i would like to know how to get the time difference between 2 times in Access 2007
i have "Time Out" in one column and "Time In" in other column and "Time Consumed" in other column.
Thanks,
Raaj.
Re: How to Subtract columns in Access 2007
In Access(Jet) you have not COLUMN as in Excel, but Fields in Tables.
If your 2 Fields are both FieldType=DateTime you have to use DateDiff(...<F1 for Help>...), here you could chose if you want the difference in second or minute.
If your 2 Fields are some different Type... pleas think about this and convert them to DateTime, or just for calculation...!
Re: How to Subtract columns in Access 2007
Sorry to attend late, just logged in
i will try your given suggestion and revert.
thanks ik2zok.
Don’t have an account yet? Register yourself now and be a part of our community!