How can i subtract time? the day remains the same. i just need to subtract two time.
Date = 2011-04-26 Starttime = 12:39:53 Endtime = 14:34:28
now i need to calculate the time difference between Endtime and Starttime.
Thanks
3 results in 0.0021 seconds.
-
subtract time. Day is same
-
ashenton started a topic How to subtract values between two queries if control value is the same (Access 2003)in AccessHow to subtract values between two queries if control value is the same (Access 2003)
Firstly: I've a fairly inexperienced access user!
I'm developing a simple stock control database and need to be able to show a total stock for each item.
So far I have two queries, both are grouped by the unique item of stock.
The first query shows how many items of stock we have received. All unique items of stock are always displayed even if there are none in stock.
The second query shows... -
steve75043 started a topic Subtract dates in current record from last record in relation to another fieldin AccessSubtract dates in current record from last record in relation to another field
Hello I hope someone can help with this. I need to subtract dates in current record from previous record for the current store.
The key fields in the form are customer, store number and date picked up.
I have used a query to put all records in order of consumer, store number and date picked up and I am using a form to view it. I can use =max([date picked up])-[date picked up] to do the subtraction but I need to only be looking at like...