Code for Counting Records and Display in Form

S

Sifford

Can anyone suggest the code that should be used to count
the number of records in a query that contains a certain
value within one of the fields on the query?

For example, I have a query named, "Query1". Query1 has
4 fields and 10 records in it. I want to count the
number of records where Field4 has a "Yes" value in it.

I then want to display the number of times that Field4
has a "Yes" value on a form and a report. What would be
the suggested code to use on a form? on a report?

I want to repeat this process for several other queries
and place their values on the same report and form. I'm
assuming the code would just be repeated with the only
difference being the query that is being pulled?

Thanks in advance for your input!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Copy previous record into form field 0
Is this possible? 0
Autonumber field in Excel that behaves the same as Access 0
Creating a Chart on form from selected data in query. 0
Display weeks from a Milestone 0
Can't Count Records in Form 4
Some mail merge fields not pulling into document 2

Top