Display query results on a form

[FryGirl]

Hi all,

I need some help with displaying the results of a query in a text box on a form.

I created a query which simply creates a count of yes and no which is stored in a table.

There are a total of 81 records in the table so the query produces CountOfYes = 10 and CountOfNo = 71 and CountOfYesNo = 81

I used an expression in the one field to query by a specific category and then three expressions.

1) CountOfYes: Sum([Force_Renewal])*-1
2) CountOfNo: Count([Force_Renewal])+Sum([Force_Renewal])
3) CountOfYesNo : [CountOfYes]+[CountOfNo]

Now on the form I would like to create a text box which would say 10 of 81. It can be more than one text box if necessary.

Am I going about this the right way?

 

[ranman256]

build a query with results,
use the form builder wizard to build a form off this query. frmResults
save
on a 'search form' enter the data , click FIND btn , which opens the form ,frmResults

 

[FryGirl]

Thank you for your help on this. I was trying to avoid using a form to display the results so I fixed it with DCount.