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).]

 

[Pat Hartman]

Change the form style to continuous forms rather than datasheet. You will have more flexibility for placing the controls on the form. Set the Show Separators property to no. Set the AllowEdits, AllowAdditions, and AllowDeletes properties to no. You should also set the ShowRecordSelectors property to no. There may be some other properties that need changing to get the effect you want.

 

[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.