comparing tables

**day92** · 12-20-2010, 07:06 PM

I have a quick question, I have three tables I need to compare. The first has the enrollment from 2010 and the 2nd has the enrollment from 2009. I need to compare the change in enrollment from the two. The third has the list of dr and I need to compare that change by a list of Dr's.

Does this makes sense?

I can attache a sample database if this helps.

**alansidman** · 12-20-2010, 08:05 PM

I need to compare the change in enrollment from the two.

What type of comparison? Count? Actual enrollees? Try to be more specific about what you are trying to do. Posting your db would certainly be beneficial.

A question on normalization. Why do you have two tables? If the data is the same in both tables except for the year of enrollment, then you should have the data in one table with a date of enrollment field.

For the third table with Dr (Doctors?) what are you comparing that to?

Alan

**day92** · 12-20-2010, 09:20 PM

Alan,

Thanks for the quick reply, Im fairly new to Access (more of an excel guy) so Im not sure how to normalize. I attached a sample DB for your reference. What Im trying to do is get a membership count change year over from my Doctor's broken down by Line of Business. We have two businesses - Commercial denoted by the CO in the business line and Senior denoted by the SR in the business line.

The 3rd table is a reference, I only want to do the report on the IPA doctors and not the foundation ones.

Does this make a little more sense now?

**alansidman** · 12-20-2010, 10:39 PM

Attached is your db with three queries. Additionally, I would reccomend that you get hold of some reading material on Access. It is not intuitive as is Excel and you need to make sure that you lose your spreadsheet mindset when dealing in a relational database.

As to normalization, I urge you to read the following

http://forums.aspfree.com/microsoft-...es-208217.html

Alan