In a query, I want to count the number of "A"s in a particular field, and then add up the total. Teachers can place one "A" or 2 "A"s in a field (some courses are held twice a week), and there is one field for each of 20 weeks (i.e. 20 string fields). Not my design. Should be simple:
absences: len([a1]) + len([a2])+ len([a2]) ....(etc) where [a1] is a string field for absences in week 1.
Won't work in a query. I can get the length function to read the field size (though this is perhaps erratic), but I cannot add them up (results are erratic.).
I tried to create a user defined query to carry out this function (in a module). Access did not like this either. Can user defined functions be used in queries?