How can I display all results from one query on a form but not in spreadsheet format

[rhounsome]

We have a query on our database which tells us of a company status which can be 1 of 4 possible values (i.e. Active, In Progress, Renewal and Deleted). However for quick referencing we wish to total the number of companies in these 4 fields. We have done this using a query but how can you view all the queries results on one page as non editable boxes and not in a spreadsheet style page. Need it to show a total for each of the status's.

 

[Chris RR]

Display the query results in a form or a report.

[This message has been edited by Chris RR (edited 09-27-2001).]

 

[rhounsome]

Cheers Pat that worked fine. However one slight problem has been found. When the query returns a 0 i.e. doesn't find any matches. It causes a problem on the form because we have buttons for reports planned against the values.

Example of Query

Active=5
Inactive=2
In Progress=0
Rejected=1

Example of information displayed on form

Records

Buttons Results
Active 5
Inactive 2
In Progress 1
Rejected Blank

Is there a way round this or does it require a macro of some sort.