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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Difference 1
Trying to calculate difference between two times in an access repo 1
calculating multiple fields in an unbound text box 1
Calculating differences between some but not all summary figures 1
Calculating this month's values in report based on accumulated values 1
Calculate variance in group footer 3
Help with Calculation on a Report 2
Unusual Calculation in Report Header 1

Back
Top