Comparing Month to Month Data

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

Guest

Hello,

If anyone can help on a set-up or have any prior databases that do this.

I am trying to create a database that compares month to month data. So say
if I wanted to compare accounts that were reviewed in March, I also want to
compare if those the March accounts were reviewed in Jan or Feb.

1st Question
What would be easier to create two form parameters to select the months to
compare? And how do I set this up to compare the two months selected data?
And is there a way to set up access to compare the two months selected from
the form parameter to compare the two tables or queries?

2nd Question
Should I leave all data in one table or separate data into each month?

Thanks,

If anyone has any databases similar to this please forward me a copy at
(e-mail address removed)
 
1. you need to give more information; i would just do it. i mean-- its'
real cut and dry
2. keep all data in one table --- seperate data by month is a pain most
of the time
 
Back
Top