how to delete information from original document and rename

G

Guest

I already have a program I use in access. I use the same program each year at
school. How can I use same set-up document without creating the document. I
need to remove information from document and rename to current year.
 
G

Guest

You don't. Instead you put something like a data/time or SchoolYear field in
appropriate tables and set up your queries based on those fields. That way
you can have multiple years' worth of data in one database. That sure comes
in handy if you ever need to compare and contrast current year data against
previous years.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top