A access program

[Guest]

Hi,
I work at a company which has a lot of shipments from various vendors. I
have a list of information from Jan 2006 till June 2006... in excel in three
columns. I would like to know how to develop a access program which would
allow me to remove the listings for the oldest month as the new month entries
are entered. I am not that familiar with Access. I just use it to make
queries, tables, simple reports and forms. I don't know if I would have to
use a macro or something similar. If anyone can help me out on this, please
let me know.
Thank You

 

[Joseph Meehan]

Hi,
I work at a company which has a lot of shipments from various
vendors. I have a list of information from Jan 2006 till June 2006...
in excel in three columns. I would like to know how to develop a
access program which would allow me to remove the listings for the
oldest month as the new month entries are entered. I am not that
familiar with Access. I just use it to make queries, tables, simple
reports and forms. I don't know if I would have to use a macro or
something similar. If anyone can help me out on this, please let me
know.
Thank You

Well normally you would not remove the older records, just identify them
by date and use the date to select the current month. As soon as you delete
them someone will discover that they have a critical need for that
information. Access can store a very large number of records so that is not
a problem.

Using a criteria in the date field of a query would hid the records you
don't want to see.