Results 1 to 2 of 2

Thread: Rollup records?

  1. #1
    Join Date
    Sep 2003
    Posts
    30

    Unanswered: Rollup records?

    I have two tables - the first contains machine info, and the second contains monthly readings.

    Table1
    Serial, Model, Location, etc...

    Table2
    Serial, Year, Month, Reading

    I would like to write a query that gives me one row for each machine that has the serial, model, and the reading for the previous 12 months. The date will be passed into the query

    Query (passing 6/1/2004)
    Serial, Model, ReadingFor200307, ReadingFor200308, ...., ReadingFor200406

    Can anyone help me with this or tell me what topic I should be scanning the help files for?

    Thanks,

    Rob

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check out Cross Tab queries.

    -PatP

Posting Permissions

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