I have a table of date/time of logons and logoffs and users names.
I have set up two queries one gets the Max time and the other gets the Min times. I have a third query that does the datediff to get the total time log on for a day(or rather it would be showing the time between first logon and last logoff for a Day.
here's my problem, the above 3 queries does exactly what I need if there is
only one day's worth of data in the table but I need these queries to work on more then one days worth of data. if I have more than one days worth of data...I get the first day first time sign on and last day last time sign off....
how can I get my queries to get all min times of each day and all max time of each day and then pair the days up to the date so i can calculate hours for each day for each user name?
I hope this make sense if you need more will try to clear it up
thanks!
I have set up two queries one gets the Max time and the other gets the Min times. I have a third query that does the datediff to get the total time log on for a day(or rather it would be showing the time between first logon and last logoff for a Day.
here's my problem, the above 3 queries does exactly what I need if there is
only one day's worth of data in the table but I need these queries to work on more then one days worth of data. if I have more than one days worth of data...I get the first day first time sign on and last day last time sign off....
how can I get my queries to get all min times of each day and all max time of each day and then pair the days up to the date so i can calculate hours for each day for each user name?
I hope this make sense if you need more will try to clear it up
thanks!
Last edited:
