• query from hell (access 2000)

    Author
    Topic
    #1770198

    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!

    Viewing 1 reply thread
    Author
    Replies
    • #1786303

      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…

    • #1786307

      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

    Viewing 1 reply thread
    Reply To: query from hell (access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: