Accumulated amount from record 1 to record 2 then to 3 etc.

  • Thread starter Thread starter Antique_Grandma
  • Start date Start date
A

Antique_Grandma

I have multiple records that can have a grand total of 100 in field a. I
only want the records starting with record 1 (being the most current date)
that will equal around 50 (what is my cap) and delete the other records. How
can I do this in a query not in reports?
 
In design view grid below your date field and in Sort row put Descending.

Then in the icon bar click in the icon that says 'All' in black letters with
white background and a pull-down on the right and enter the number of records
you want.
 
Back
Top