Results 1 to 3 of 3
  1. #1
    quidlat
    Guest

    query from hell (access 2000)

    hi guys!

    is there a way i can combine three queries so that the field from each query containing the same type of information can all go into one field? i need to use this combined query for a report.

    Here is the problem:
    Some of my servers are backed up on Sunday, while some are backed up on Saturday, and the rest on Wednesday. So I have three queries each detailing the server name and the amount of bytes backed up. Now I want the amount of bytes backed up from each query to go into the field "Total_Size" in the combined query, so that i can just reference this field in my report.

    How can i do this?

    Thanks in advance!

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query from hell (access 2000)

    Altho I havent tried this myself, i would approach it with 3 Append data queries controlled from a single VBA procedure, which is itself controlled by say, a button on a form. How to call each query is what I need to learn myself; i think DoCmd RunSQL might work...

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query from hell (access 2000)

    in the query that queries the other 3 create an extra field called Total_Size and make it equal the other 3 added together ie in the field cell type: Total_Size:[Field1]+[Field2]+[Field3].
    That's the way I do it and it works.
    Peter Herworth

Posting Permissions

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