Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Design (Access 2000)

    Hello Loungers

    My database records quantities of materials ordered and the sites to which the materials are booked.

    The client requires a monthly report, submitted on a spreadsheet, showing materials per site for the period and cumulative project total.

    I

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

    Re: Query Design (Access 2000)

    I don't know enough about the setup of your queries to give specific advice, but perhaps you can create a union query to combine the results of the period query and total query. Union queries have to be created in SQL view; they look like this:

    SELECT * FROM Source1
    UNION
    SELECT * FROM Source2

    where Source1 and Source2 are the names of the tables or queries you want to combine.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Design (Access 2000)

    Thanks Hans

    I was deliberately hypothetical otherwise the post would have been far too long!

    I

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

    Re: Query Design (Access 2000)

    The problem with your SQL is that there is no link between the source queries, so each record returned by a source query is combined with each record returned by each other source query.

Posting Permissions

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