Adding an auto count for last 24h on new record entries starting at 7am

[ManaLyn]

I am trying to figure out a way in either coding on the form or by use of a query to add the records in a field for a workday (stating at 7am and ending at 6:69am the next morning). Is there a way that I can make a text box add a number each time a new entry is saved? Or to add the new number to the last record?


I am trying to record the number on inspections an operator does per day, along with how many of the inspected items are rejected. At the moment I have a field set up for each of these with the "inspected" automatically recording 1, and if there is a rejected button pushed entering a 1 in that field, (0 if not rejected).
I am open up for suggestions.

[jzwp11]

Welcome to the forum!

Could you provide a list of fields in each table with which you are dealing?

I would think that you would record the date/time of the inspection, the item inspected and the disposition (rejected or not rejected). You would then just count the records with in the date/time period you want. This can be done easily with the DCount() function provided your tables are set up properly.