+ Reply to Thread
Results 1 to 5 of 5

comparing tables

  1. #1
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    comparing tables

    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.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: comparing tables

    Please Login or Register  to view this content.
    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: comparing tables

    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?
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: comparing tables

    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
    Attached Files Attached Files

  5. #5
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: comparing tables

    Alan, thanks for your help and the reference material. It appears I have a lot of reading to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1