Looking up multiple Records

[Guest]

My question might seem a bit novice, but my experience with Access is quite
limited. Thank you for your patience.

My current database is using three tables (with the following fields):
1 - DATES (date, fiscal period)
2 - LOCAL Revenue on the Books (date, jan, feb, mar, .... dec)
3 - NATIONAL Revenue on the Books (date, jan, feb, mar, .... dec)

The date in each table serves as the primary key for the table and each the
date fields are matching keys accross the three tables.

Essentially, the LOCAL and NATIONAL Revenue on the books changes and is
updated on a daily basis.

What I'm seeking to accomplish is to use either a Form or Report, etc. to be
able to compare two separate records together using the DATE as the primary
key and show differences and totals between the two dates. For example,

I would enter the date 03/14/06 in one field (or pull it up using through a
combo or list box, or even scroll to the specific date, etc.) and the revenue
on the books would be shown for its respective months (jan, feb, mar....). I
can then enter a different date pulling up its respective data and show
totals and differences between the two. I would need to be able to make
cosmetic changes to this setup as well.

Thanks again for any help,

 

[Guest]

Essentially, the LOCAL and NATIONAL Revenue on the books changes and is
updated on a daily basis.
Are you adding records on a daily basis or revising the current records?
Does the records look like this --
1/2/05 14.55
1/3/05 33.43
---
11/22/05 23.12

Are is the record something like this --
2005 Jan Feb ---------Nov Dec
2005 1003.97 2312.45 --- 2134.78 2254.49

 

[Guest]

Karl,

The records look as follows:
Date Jan Feb Mar ...... Dec
01/14/06 54 32 29 5
01/15/06 59 36 31 6
01/16/06 62 42 33 6


I would like to be able to compare different dates to one another as my
choosing.

 

[Guest]

You need to revise your table structure so that your data looks like this --
1/14/2006 JAN 54 LOCAL
1/15/2006 FEB 59 LOCAL
1/16/2006 MAR 62 LOCAL
1/14/2006 JAN 32 LOCAL
1/15/2006 FEB 36 LOCAL
1/16/2006 MAR 42 LOCAL
1/14/2006 JAN 29 LOCAL
1/15/2006 FEB 31 LOCAL
1/16/2006 MAR 33 LOCAL
1/14/2006 DEC 5 LOCAL
1/15/2006 DEC 6 LOCAL
1/16/2006 DEC 6 LOCAL

 

[Guest]

In doing so, how will I be able to accomplish my main goal.