I am creating a drug abuse database. One results come back, I want to break down some stats. Table looks something like
NAME - SSN - DRUG 1 - Drug 2 - Drug 3 - Etc
I have a form for creation of the records, combo box for selecting THC-COC etc...
I want to count all fields, for all records in the table for THC, and COC, and DMETH and 6Am, etc...
How can I go about this?
Count and Groupby is no working together, plus the BEST option would for it to have a user input for Criteria, where I type the drug i am looking for and get the results I need at that time.
Any suggestions??