Hi i have a list of records conatining a roomnumber, area & condition (rated 1 to 5).

I need to summarise the records by the total areas for each condition.

I cant think of a simple way to do this other than 5 calculations eg case(contition=1,area*1,) and five summary fields.

Is there a better way? There are other categories in the record that may come into play later on.

edit: Im guessing I need to use the getsummary calc but am not get very far with it

thanks

Make a separate table called Condition and link the new table to Roomnumber by the condition field. Make one summary field for area, sum_area, equal to the total of area. Then place this field on the layout for Condition. You'll have five records in Condition. The sum_area field in each Condition record will give you the corresponding area.