Recent content by barnstar

Alright plog. Absolute genius. Thank you very much.

Thanks for the response. The datatype of the time field is 'Date/Time' and the table name is 'tblShifts'. The Time field names are 'StartTime' and 'EndTime'. Hope you can help. Thanks

Thanks for your reply. Sorry I didn't really explain myself very well. I need the count to be broken down into half hour time slots. Below is an example of what I need. 07:00 07:30 08:00 08:30 09:00 0 0 1 1 1 etc. Hope someone can help Thanks

I have a database that keeps track of everybody's shift times. I need to be able to count how many people were in for each half hour of the day. For example if a shift time is 08:00 - 18:00 I would have a count for each half hour between these times. I have tried many things but cannot get...

Hi there, I am currently working on automating an annual leave system at work but am really struggling with something. The leave is done in half hour slots e.g 8:00 - 8:30, 17:00 - 17:30 and am wanting the user to submit a form asking for leave for a date(s) & time on a form & for it to check...