How do you write a formula that calculates the difference between.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write calculate the difference between the last and first
values of a table for a report. How would I do this? Thanks
 
michelle said:
I am trying to write calculate the difference between the last and
first values of a table for a report. How would I do this? Thanks
Click to expand...

The concepts of "Last" and "First" really don't apply in a database unless
you are looking at the data using a query that imposes a sort order on one
or more of the fields tables. If by first and last you mean "the order in
which the records were entered" you will only be able to determine that if
you have a DateTime field that indicates when each record was entered or if
you have an incrementing numeric field that reflects the order of entry. Do
you have such a field?
 
Back
Top