Unanswered: Counting records in query and populating new field with total results..
Hi there, I'm new to MS Access...
Can anybody please help me with the following issue:-
I have a Query table and I need to count the instances of records "L1", "L2" and "L3" in the 'Query Table' for each field (70+) and create / display new fields called "Totals_of_L1" , "Totals_of_L1", "Totals_of_L1" (sub totals counts of L1. L2 & L3 per record/row ?