The Apprentice on Access

  • Thread starter Thread starter GabrielG
  • Start date Start date
G

GabrielG

One of the fields on a table contains text data, basically Yes or No
How can I make a query and report to count how many Yes and No inputs I have
?
Please, if you have any feedbacks try to explain it as simple as possible.
I am a rookie and I am just scratching the surface on Access.

Thanks in advance.
Any help is greatly appreciated.
 
Gabriel,

Here's the basics of it...
Make a query in design view, based on your table.
Add the field that contains the Yes or No text data, to the query design
grid.
Also add the primary key field from the table to the query design grid.
Make it a Totals Query (select Totals from the View menu).
In the Totals row of the grid, leave it as Group By in the YesOrNo
field, and in the column with the PK field, put Count.
Run the query (click the toolbar button with the red ! icon).
You can base a report on this query, or include this query within
another query that your report might be based on, but there are also
other ways of getting this information directly within the setup of your
report... depends a lot on the overall structure and requirements of the
report.
 
Back
Top