Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Unanswered: Select Certain Records for Calculations

    Hello, I am pretty new to Access, so I would appreciate any help anybody can give me!!

    I have a table that is trying to analyze the erosion of Offroad Vehicle Trails. This is the info on an access table that I was given.

    Date Point Measurement
    7/21 3 19
    7/22 3 20
    7/23 3 20
    7/24 3 21
    7/21 6 18
    7/22 6 19
    7/23 6 20
    7/24 6 20

    Each is a separate record. I need to calculate the difference between measurements on the separate days at the same point.

    For example...
    The difference of measurement between 7/21 & 7/22 at Point 3 = 1. The difference of measurement between 7/21 & 7/23 at Point 6 = 2 etc.

    I would like the end result to be a table with the following...

    Point DiffDay0721 DiffDay0722 DiffDay0723 DiffDay0724
    3 0 1 1 2
    6 0 1 2 2
    etc...

    I have tried to work with DSum and DLookup, but I ended up with a DHeadache! Like I mentioned before I am new at this and any help will be appreciated. Thanks!

  2. #2
    Join Date
    Sep 2004
    Posts
    10
    Have you made any progress?
    How do you want to display the results? (on a form, on a report?)

Posting Permissions

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