Hi:
I posted this same question before but it regarded using checkboxes (which I am not using now in my DB). Now, I am wondering how to do this with different elements on a dropdown menu.
I would like to be able to make a report (no graphics, just a report) and a chart (bars and numbers) from my database to report how many records have a certain dropdown menu item.
For example, let's say I had the following in a drop down menu:
Call
Email
Wait for call
No Calls
How would I get a report that totaled them and read some thing like this:
Call 10
Email 2
Wait for call 35
No Calls 3
What formulas should I add in to a summary field to do this?
Also, what do I need to do in my layout to accomplish this? Do I need to do a mailmerge to a word document?
I have moved away from doing this with checkboxes since a drop down is easier...does AW read the dropdown elements in order 0, 1 ,2, 3, etc... or in some other fashion?
Thanks for everyone's help...
-v