Lookups

J

JEM

Can anyone help.

I have entered data from questionnaire into database. For the answers I
have created a lookup ie, either yes or no. In retrospect I should of put it
as a Yes/No data type. However, what I need to know is how do I get access
to calculate how many Yes and how many No's so I can put it in a report.
Example

Did you like the illustrations? Yes 32 No 2

I normally do this in excel and am quite new to access.
 
J

Jeff Boyce

One approach might be to create a query and count the number of each (see
Totals query in HELP).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top