G
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,
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,