I am trying to create a query that will sum up production numbers based on a Date criteria. Normally not a problem but, this needs to run daily so it needs to be somewhat dynamic. Basically, I need to know how many pieces were produced between yesterday at 3AM and today at 3AM each day. When user enters their data, the record is stamped with the date and time they entered the data. Normally, I would use Between Date()-1 and Date() or >=Date()-1 but, because records are entered after midnight, this does not work as needed.
Thanks in advance for your help.
