I have a query called qrytemple.
In the query I have a field called Percentage.
It calculates precentage for each record.
I am not getting no error Messages.
I am using a text box for the following code:
" [Unit ]= ('278th ABCT')")
I need a total for all the percentages from each unit.
(and this code is just counting the first record)
I also need a over all total.
My code looks like this and it works:
(this is also only adding the first record)
How do I get these two codes to sum?