Reyesrj
asked on
Count Answers in Access 2007
Hi All,
I have a 2007 MS Access Data base. My table looks something like this:
Names Over 18?
Name 1 Yes
Name 2 Yes
Name 3 No
Name 4 No
Name 5 Yes
Name 6 Don’t know
Name 7 Unknown
Name 8 Not Sure
Is there a way to run a report that will list the answers and show the total count such as:
Over 18 Count
Yes 3
No 2
Don’t know 1
Unknown 1
No 1
I don’t want to use the drop down and require a specific answers, just in case there is a need to enter something other than what obvious. The table above is just an example so please work with me. This will also help with misspelled words and later I could create a drop down list such as Yes, No, Not stated. The data base is new and we are still working on how the data is to be entered. My data base structure will change once we work out the bugs.
Thanks in advance.
I have a 2007 MS Access Data base. My table looks something like this:
Names Over 18?
Name 1 Yes
Name 2 Yes
Name 3 No
Name 4 No
Name 5 Yes
Name 6 Don’t know
Name 7 Unknown
Name 8 Not Sure
Is there a way to run a report that will list the answers and show the total count such as:
Over 18 Count
Yes 3
No 2
Don’t know 1
Unknown 1
No 1
I don’t want to use the drop down and require a specific answers, just in case there is a need to enter something other than what obvious. The table above is just an example so please work with me. This will also help with misspelled words and later I could create a drop down list such as Yes, No, Not stated. The data base is new and we are still working on how the data is to be entered. My data base structure will change once we work out the bugs.
Thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks