B
Bill Schuh
Good Morning...
I have not been working with Access for about three years now due to a job
change and now I am writing a database to help me track pre-printed forms.
Our truck drivers pickup a pre printed numbered form from the office before
they leave for their pickups. The drivers fill in the blanks giving me the
specifics about what they picked up and from whom. Once a week I enter the
information into the database which produces both invoices and rebate
reports for our customers.
What I am looking to do is create a query that will list the missing numbers
from the forms the drivers take after I enter them into the database. This
has never been tracked before and last month I found we were missing about
20 of them.
Is there a way to have the query just list the missing numbers?
I am using Access 2000.
Thanks a million! This query could save me a couple of hours each month.
I have not been working with Access for about three years now due to a job
change and now I am writing a database to help me track pre-printed forms.
Our truck drivers pickup a pre printed numbered form from the office before
they leave for their pickups. The drivers fill in the blanks giving me the
specifics about what they picked up and from whom. Once a week I enter the
information into the database which produces both invoices and rebate
reports for our customers.
What I am looking to do is create a query that will list the missing numbers
from the forms the drivers take after I enter them into the database. This
has never been tracked before and last month I found we were missing about
20 of them.
Is there a way to have the query just list the missing numbers?
I am using Access 2000.
Thanks a million! This query could save me a couple of hours each month.