Formulas in Access Queries

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

Guest

HI... please help with a formula for below...

I need to filter nemeric stats in ascending order then divide the maximum
value by the 60th value. i'm doing this in a querie, however if there is a
better way... i'd be glad to hear it.


thank you
 
HI... please help with a formula for below...

I need to filter nemeric stats in ascending order then divide the maximum
value by the 60th value. i'm doing this in a querie, however if there is a
better way... i'd be glad to hear it.


thank you
Click to expand...

That may be a bit tough, since Access doesn't keep track of record
numbers. Do you mean that if the table has 245 values you want the
60th of them? What if it has 24500 records? Worse, what if it has 58
records?

You'll certainly need to use a Query but off the top of my head, I
can't think of any easy way to write that query! At the very least
you'll need two subqueries.

John W. Vinson[MVP]
 
The data is entered by date and there will never be less that 60 entries. so
the query needs to filter the 60th value within a specified period.if the
date period is more than a day, it must average the values entered per
employee and then filter the 60th value.
 
Back
Top