hi experts.
i have an attendance table. its fields are ( auto id number, names, and 1,2,3,4,5 up to 30 that represents 1 month). now in each field that name 1,2,3,4 etc contains "p" as presents, "d/o" as day off.
now what i want to make a query is to count total presents of each employ. so please tell me how to count a range of fields or coloumns same as like an excel.
thanks
id name 1 2 3 4 5 total 1 robert p p p d/o p =count(p) 2 john p p p d/o p 4 3 peter p p p d/o p 4