Hello,
I have a simple access table with a date and a quantity (inventory) entry for each day that has inventory. Days with zero inventory are not entered (data is sourced online from a list of those locations with current inventory).
Is there a way to count the number of days where there are no entries in a record set for a given period.
Example:
Over a three month period the first 30 days have inventory, then none for a month and then inventory for the last month. So for the 30 days in the middle there are no entries in the table. Can I somehow count the number of days without entries?
Thanks,
Ken