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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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?
 
Back
Top