Help creating query

[WILL]

I work for a doctors office usually just doing grunt stuff, backups and restores and updates and other things of the sort. But now I have been asked to create a database which shows procedures that we have done through out the year. Im trying to create a query that would look back over the past 11 years the doctor has been in practice and would pull the information it was asked for. For instance the billing manager may want to compare january of 2003 with january of 1996 As shown Below. Any help or guidance would be greatly appreciated.
Procedures Jan-03 Jan-96
Injections 20 45
Consultations 10 30
Office Visits 5 15
This is how the tables are set up the procedures are constant and never change
Table 1
Procedures
Injections
Consultations
Office Visits
Each year is on a different table
Table 2
Jan-03 Feb-03 Mar-03
15 10 15
20 31 35
22 45 22

 

[Duane Hookom]

You have several issues with your table structures. Different tables for
different years is not good. Different fields for different months is not
good. Your data should be stored in a table with a structure like:

tblProceduresPerformed
===================
PPID
Procedure
ProcDate
ProcCount

If you intend to keep the structure as is, you might as well use Excel.
Trying to work in Access with un-normalized tables creates a lot of extra
work.

--
Duane Hookom
MS Access MVP

I work for a doctors office usually just doing grunt stuff, backups and

restores and updates and other things of the sort. But now I have been asked
to create a database which shows procedures that we have done through out
the year. Im trying to create a query that would look back over the past 11
years the doctor has been in practice and would pull the information it was
asked for. For instance the billing manager may want to compare january of
2003 with january of 1996 As shown Below. Any help or guidance would be
greatly appreciated.