Time Date Query

R

Rocket

Hello,

I have a form that records Date In, Date Out, Time In, and Time Out and I am
looking to create a query to give me the differance in minutes. Each of these
fields are seperate. I was able to create =[DateIn]+[TimeIN], but I cant seem
to get it to due something like this
=([DateIn]+[TimeIn]),([DateOut]+[TimeOut]) then use the date time diff
formula. Thanks for your help in advance.

Rocket
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateDiff past Midnight 8
Creating Forms 0
Storing a date in UK format 17
Time clock 2
Calculated a field in a subform. 9
Routine not working 12
Time and date specs in SQL 1
Date and Time Picker 6.0 0

Top