Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unanswered: How do I calculate fields in two tables on a query/report?

    I have two tables carrying data entered in by a form.
    Cost Data table (Serial #, Unit #, Date of Record, Maintenance Cost) and

    Meter Reading table(Serial #, Unit #, Date of Record, Meter Reading)

    I want to divide Maintenance Cost by Meter Reading to get my cost per hour and I want a report to show this. I also need to figure out a big problem I'm having. As these meter readings are entered in, they sometimes start over if they're replaced. How would I get Access to add the next meter reading to the previous? For instance...

    Period 1 meter reading is at 500 hours
    Period 2 meter reading is at 150 hours

    The real usage for that period is 650 hours. Any ideas?

  2. #2
    Join Date
    Jul 2009
    Kempton Park, South Africa
    Hi hornedfrogs123, have you figured this one out yet? I have the same issue!

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    I still can't figure out what the problem is.

    How do you calculate fields that are in two different tables? The same way you would in one table.

    I want to divide Maintenance Cost by Meter Reading to get my cost per hour
    CPH: [Maintenance Cost] / [Meter Reading]

    So, did that help? I doubt it.

    The other problem should be in a DIFFERENT topic.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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