Comparing one year to the next

[Amy]

I have a bunch of forms and data that I have created and I
am wanting to compare two things. The first is one month
this year to the same month last year. I am also wanting
to compare as the year goes on the year to date data of
this year to the year to date data of last year.

I am so confused on where to begin with this, can anyone
help?

Thanks,
Amy

 

[John Vinson]

I have a bunch of forms and data that I have created and I
am wanting to compare two things. The first is one month
this year to the same month last year. I am also wanting
to compare as the year goes on the year to date data of
this year to the year to date data of last year.

I am so confused on where to begin with this, can anyone
help?

Thanks,
Amy

The first thing to remember is: Forms DON'T contain any data. A form
is just a window - a tool to manage date stored in Tables.

You can create a self-join Query joining your table to itself to
compare data from one time period to data from a different time
period. What's the structure of your table (or tables)?

 

[Tom Wickerath]

Hi Amy,

I have a working sample database, which I believe does exactly what you want. I sweated
over this DB for many long hours last year, before finally getting everything to work
properly! I can send you a copy of this database if you'd like to see it.

Tom Wickerath
_______________________________________


I have a bunch of forms and data that I have created and I
am wanting to compare two things. The first is one month
this year to the same month last year. I am also wanting
to compare as the year goes on the year to date data of
this year to the year to date data of last year.

I am so confused on where to begin with this, can anyone
help?

Thanks,
Amy

 

[Amy]

I have three tables that each contain the month and the
year and then numbers under each different category.
Beyond the month and year, everything else is simple
intergers.

-----Original Message-----

 

[John Vinson]

I have three tables that each contain the month and the
year and then numbers under each different category.
Beyond the month and year, everything else is simple
intergers.

How do the three tables differ? How are they related? By "under each
category" do you mean that the Category is a fieldname? How many
categories in all?

Sorry to be coming back with more questions but I'm not sure I
understand the structure well enough to suggest a solution!

If it were just one table, you could create a Query adding the table
to the query grid *twice*. Join the two instances by Month; and put a
criterion on the first instance's Year field of 2003, and the second
of 2002 to compare matching months in 2002 to those in 2003. But with
three tables I'm not sure what joins to what!