Intervals

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

Guest

I have a query that displays OrderQuantity and CostPerUnit. I want to group
the data in the query so I can see the average CostPerUnit for interval
ranges of OrderQuantity; For example:

Ordersize CostPerUnit
1 to 500 1.50
501 to 1000 1.25
1001 to 1500 1.10

How do I get this type of grouping?
 
Do you have a table with MinOrderSize, MaxOrderSize, IntervalTitle? That
would be a good place to start. You can then add this table to your query
and set the Criteria under OrderQuantity to Between MinOrderSize And
MaxOrderSize. Add the IntervalTitle field to Group By and Average your
CostPerUnit.
 
Way Cool!!!! Great idea.

Duane Hookom said:
Do you have a table with MinOrderSize, MaxOrderSize, IntervalTitle? That
would be a good place to start. You can then add this table to your query
and set the Criteria under OrderQuantity to Between MinOrderSize And
MaxOrderSize. Add the IntervalTitle field to Group By and Average your
CostPerUnit.
Click to expand...
 
Back
Top