ACCESS- How to eliminate current payment info to start a new year

A

Avram

I wish to use the curent database so that I do not need to reenter basic info
on each person in the database.

But I wish the database to only reflect the new info.

How can I do this?
 
J

John Vinson

I wish to use the curent database so that I do not need to reenter basic info
on each person in the database.

But I wish the database to only reflect the new info.

How can I do this?
Click to expand...

In a properly normalized database the person information would be
stored in the People table, and payment information in a separate
Payments table; there would be no need to reenter anything. For that
matter, in your Payments table there shouldn't be anything special
about a new year - you could just enter the payment date and payment
amount, and use Queries to display the payments from a particular
year. The previous years' data could be kept (you may want it for year
to year comparisons for example) but you could use a Query selecting
only the current year's data to display payments.

How are your tables structured?

John W. Vinson[MVP]
 
A

Avram

John Vinson said:
In a properly normalized database the person information would be
stored in the People table, and payment information in a separate
Payments table; there would be no need to reenter anything. For that
matter, in your Payments table there shouldn't be anything special
about a new year - you could just enter the payment date and payment
amount, and use Queries to display the payments from a particular
year. The previous years' data could be kept (you may want it for year
to year comparisons for example) but you could use a Query selecting
only the current year's data to display payments.

How are your tables structured?

John W. Vinson[MVP]
Click to expand...

I worked off the Northland sample database. In that database the field that
totals payments appears and it would not be easy to set it to read the totals
only for the current year.

But I saved the prior year, and then using update queries set the pertinent
fields to zeros. I label each database with the proper year.

Thank you for your interest.

Avram Kalisky
 
Top