Creating Data Buckets and show sum of values

[digvijay]

Hi all,



i have a sheet in which the milk qty is given with their corresponding Fat% and SNF % like this

Qty Fat% SNF%

1200 5.16 8.56
1300 6.20 9.27
1500 7.20 9.34

I have two things to ask

One is i want to create a query which will return sum of Qty of milk based on the buckets where Fat% is between 4-5; 5-6 and 6-7
second is i want to create a query which will return sum of Qty of milk based on the buckets where Fat% is between 4-5 and SNF % is between 8-9; where Fat% is between 5-6 and SNF % is between 8-9

Please help me out

[orange]

Sheet is not a relational database term; it's a spreadsheet/Excel term.

You can have a query to select data from a table(s).

You could investigate the Partition function in Access.

[June7]

Need to construct fields in query with expressions that calculate these range values. Then use those constructed fields for grouping criteria. As orange suggests, Partition() may be one way to accomplish this calc. Switch() is another. Choose() can also be useful but probably not for your data.