How do I reuse the outline of a form without redoing it all

S

sarah_g_779

I want to use my database to create monthly reports of my staff's pay and
deductions, but I don't want to have to create a new table/form/report for
every month. How can i use what i have already created, and just add a form
for the next month, and the next month, without having to redo it all each
time?
 
L

Larry Linson

Without more information about the data you have and the tables in which you
have it stored, I don't think anyone can offer a useful suggestion. Here are
a couple of "guesses" that might help, but if you clarify, someone will
likely have a more specific solution.

If you have all the data that is identical except for the date stored in the
same table, with date as a field, it should be a simple task to create a
monthly report by using either the WhereCondition argument of the
DoCmd.OpenReport or by creating the SQL to replace the Report's Record
Source using the month as a Criteria.

On the other hand, if you have separate tables for each month, you are
dealing with a problem of "unnormalized data" and it may be a bit more
difficult, but you might be able to create the SQL to replace the (same)
Report's Record Source using a different table as the source. But, as you
may want to do more with this data, later, it would be a good idea to use
proper relational table design.

Larry Linson
Microsoft Access MVP
 
S

sarah_g_779

thank you. I'm very new to this whole access thing, and i really only know
the basics. The first solution you wrote here sounds like what i need. But,
how do i use the WhereCondition or SQL?
 
Top