Hi, I am new to MS Access , just facing a problem,
I have a report in which I am counting all the records at the end . Total Records =Count([id]) where id is autonumber.
Now I have to count a specific field which is a text field , it has only three possible values, lets say its a text field...