Lookups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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

Query: how to count up data from different fields 3
Same record/Primary key in multiple tables 0
replacing lookuptables 2
Research project: one database or several 3
yes/no for old data 4
Create records automatically in related table? 2
Broken query/relationship 5
Research Project: one database or seperate 1

Back
Top