K
Kat
My report is driven by a query which has a field titled [Amount Paid] and a
check box field to mark if the amount has been paid. My report is seperated
into [Amount Paid] Yes and [Amount Paid] No. In my report I want a total for
the field [Sales] but only when the amount has been paid, meaning the [Amount
Paid] = YES.
I'm thinking it should look something like this:
iif([Amount Paid]="yes", Sum([Sales])
There's a lot more to the report but this is where I'm having trouble and so
I tried to just explain this section. Any ideas? Thanks.
check box field to mark if the amount has been paid. My report is seperated
into [Amount Paid] Yes and [Amount Paid] No. In my report I want a total for
the field [Sales] but only when the amount has been paid, meaning the [Amount
Paid] = YES.
I'm thinking it should look something like this:
iif([Amount Paid]="yes", Sum([Sales])
There's a lot more to the report but this is where I'm having trouble and so
I tried to just explain this section. Any ideas? Thanks.