It has been a long time since I used access can someone explain to me what this code is doing? Someone previous to me created it.
AND ((HRA_DATA_ALL_03092012.HospAdmitPastSixFlag) Like "*y*")
AND ((Format([NumDailyMeds],"General Number"))<>" "And (Format([NumDailyMeds],"General Number"))<>"0"
And (Format([NumDailyMeds],"General Number"))<>"1" And (Format([NumDailyMeds],"General Number"))<>"2"
And (Format([NumDailyMeds],"General Number"))<>"3" And (Format([NumDailyMeds],"General Number"))<>"4"
And (Format([NumDailyMeds],"General Number"))<>"5" And (Format([NumDailyMeds],"General Number"))<>"6"
And (Format([NumDailyMeds],"General Number"))<>"7" And (Format([NumDailyMeds],"General Number"))<>"8"
And (Format([NumDailyMeds],"General Number"))<>"9")
the NumDailyMeds field in the database is only one field where they put how many medications a person is on. Also I have fields that are questions with drop down list of 4 possible answers I need t create a code that can count each answer. ex: Possible Answers: "Not much, A little, Never, Not at all" I want to know how many of each of these answers are in the database. Is that possible? Please help Thanks!!!