Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combine data from 3 tables (2002)

    Hi all, I need to combine data from 3 separate tables (same field names in each table) into one query. can't use a union query as i need to be able to update that query. can this be done? thanks, Van <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combine data from 3 tables (2002)

    How would Access know which table to update? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Your requirements are contradictory, as far as I can see.

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combine data from 3 tables (2002)

    Thanks Hans. I see what you mean. I have patients being booked into either beds 1, 2 or 3 (three separate tables). in each table there's a check box that is checked if the patient doesn't show for their appointment. would like to be able to show, on one form, those patients who didn't show, then have another check box on that form (called: 'follow-up completed' for example) that would remove the patient from the form when checked off. Maybe i'll just need to work with 3 separate forms. Van

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combine data from 3 tables (2002)

    Why do you have separate tables for each bed? If you combine the records into one table, with an extra field specifying the bed, you can filter this table in various ways - all patients for a specific bed, or all patients who didn't show up, or ...

Posting Permissions

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