can i calculate the total of a particular text field?

[Guest]

i have a field called "heat expense", the contents of which are: under 50,
50-100, and so on. i need to find out how many people pay under 50, how many
people pay 50-100, and so on. i cant calculate the total because it is not a
number or currency but a mix of both. i cannot perform mathmatical
calculations on memos right? there must be a way to find out how many fileds
contain "under 50" total.

 

[Guest]

Hi

Group by [heat expense] and to count use the expression count(*)

In SQL...

SELECT [heat expense], count(*)
FROM MyTable
GROUP BY [heat expense]

This assumes you want to count every record.

Regards

Andy Hull