Each day a user is supposed to import a list of information into a
database table. The user only has 30 days to import this information.
After 30 days the information is lost. I need to be able to create a
form or a report or something that a user would be able to review and
show that a day was missed doing the import (indicating they forgot to
import that days information).
The table the information is being imported into is called
tblTransaction. One of the fields of the table is TxDate which is a
date field. Each day has multiple transactions with the same date and
a duplicates Ok for the TXDate field. I can run a query and get the
days that have transactions and the number of transactions for that
day. I use todays date and the date function that gives me today's
date -30 days. Each time the query is run it is for the past 30 days.
This works fine but the user has to look down to query to see if there
is a missing date.
I would create a table to denote the import was done at the time of
the import but sometimes the import data is for multiple days and the
import is not always done on the same date as the transaction date.
I am sure there is a way to just print or display the missing days but
I just cannot seem to make it happen.
Is there someone out there that would help?
Thanks