I have hopefully a relatively simple question.
I have a form that displays results from a query in Access.
I created a textbox that totals my "amount" field by placing the formula "=Sum([amount])" for the Control Source.
What I actually need is a running total for the records that are "Assigned"
so to look something like
=Sum([amount]) where [Assigned] = 1
I tried the above formula but it didnt work. Can somebody point me in the right direction