Saving it for different years

[Michael Koenning]

I use access to track income and types of expenses for many different oil
and gas leases. Tables I use are lease locations, income/expense,
locations, and states. I find it's so confusing when working with different
years and ease to confuse years when correcting items. Is there a way I can
save the (tables reports, queries, etc) for different years, 2003, 2004,
etc. I realize I will lose history comparisons on lease to different years
yet my tables have gotten so large with the many monthly entries. When I
look to save it I see tables, querys, reports. I'ts so easy in Excel or
others to do a save as on a file.

Thank you in advance for any responses.

 

[John Vinson]

I use access to track income and types of expenses for many different oil
and gas leases. Tables I use are lease locations, income/expense,
locations, and states. I find it's so confusing when working with different
years and ease to confuse years when correcting items. Is there a way I can
save the (tables reports, queries, etc) for different years, 2003, 2004,
etc.

One suggestion would be to have a form (perhaps your startup or menu
form) always open, with a textbox for the year in it. You can use a
criterion on all your queries on tables with datefields such as

WHERE Year([datefield]) = Forms!frmStartup!txtYear

This will *store* all the data, but only display a year at a time.

Access databases ARE NOT SPREADSHEETS, and are not even files.
Splitting your database into pieces is a road to chaos, not to
simplicity!