Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

MS Access 2003

Home Forums Office Office XP / 2003 General Issues MS Access 2003

Viewing 1 post (of 1 total)
  • Author

  • shadragon

    I have an easy task, but not sure how to do it. I have three tables:


    Each has different information in them as they come from three different sources that I do not control and import daily. There is no way to relate the info between as there are no common key fields.

    I want to take selected fields from each and put them into a fourth table, lets call it Table4. BUT I need to put the same info from each table into the same field of Table4


    C has 12 columns (Account Number, Amount, Date, Notes, Reference…etc)
    MS has 7 columns (Account Number, Cost, Date, Time, Buyer, Name…etc)
    S has 9 columns (Reference, Price, Date, Commission %, Amount…etc.)

    In Table4, I want to cherry pick fields in those above tables into one.

    In Table C, “Amount” goes into Column 5 of Table4. I also need “Cost” from Table MS to go into the same column and “Price” from Table S in the same column.

    So if I do Account Number, C and MS go into column 1 of Table4, but as Table S has no account number field, it will be blank.

    Once done I can export Table4 to an Excel sheet so one of our people can fill in the blanks from their paperwork. See example below.


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: