This is in the same Access project that my last question was from. I'm using a function in Access to count completed product from a table based on date, Product ID, and time. The problem is that our last production quarter on second shift is from 11:00 PM on one date to 1:00 AM on the next. How can I make the count continue from the first day into the next, or can I? There is a date field and a time field in the table instead of a single DateTime field. I can't change that as the database is part of a program written by a contracted software company for our production line. I'm not sure how to manage the criteria on the date field either since the date is flipping from 11:59 PM to 12:00 AM. Am I going to have to do two seperate queries? One for 11:00 PM to 11:59 PM and one for 12:00 AM to 1:00 AM on the next day? If so, how can I show the total for these two in a single subform?
I'm teaching myself Access, SQL, and VB so I need all the help I can get. Thanks!