hi all
got a quick question, please see the images below
basically i want a new table to show this
ID/loc desc/AM counts/PM Counts/Sat Counts/Sum ( / seperates each column)
as you can see, i go to calculate the totals for each ID but cannot seem to add additional columns with what I want, each ID and Count (AM/PM or SAt) is a new data entry so does it not like that combined into 1 row?
Sorry I am new to access and tryin to learn this for my job
thanks