Counting the Number of text entries

[C2680mor]

I have a table of clients where the data entered relates to whether the client has "increased", "decreased" or "remained constant" in terms of the amount they have ordered.

I would like to present a breakdown of the results, and so need to be able to create a total of the 3 responses. Historically I have done this by importing it into other software to analyse, but am sure it can be done directly with Access.

I have looked through the help for an idea, but am not getting anywhere with this.

Any advice is appreciated, thanks,

Chris

 

[SQL_Hell]

Hi Chris

How about a query with the group by clause, say for example your "increased", "decreased" or "remained constant field is called 'Ordered'
and the table is called table1

(sorry but you didn't give me any field or table names to work with)


SELECT Count (Ordered) as Count, Ordered
FROM Table1
GROUP BY ordered