How do I seperate Info on a report?

[Matt W via AccessMonster.com]

I've built a report based on a crosstab query of Dates, Stores, Approved
Credits, Denied Credits and Costs. The report is Grouped first by Month, then
by Stores. There are three summeries for each store. Approved Credits: Sum,
Avg,Total; Denied Credits: Sum,Avg,Total; and Summery: Sum,Avg,Total.

The report shows the groupings correctly. However I need to show the cost by
store of the Approved Credits and Denied Credits seperately. In this report
it lumps them together. In design view I can see that it shows =sum([Cost])
for both approved and denied. What do I type in to make it differentiate?

Thanks in Advance.
Matt Wollert

 

[George Nicholson]

Maybe something like:
=Sum(iif([DeniedCredit]>0, [Cost], 0))
=Sum(iif([ApprovedCredit]>0, [Cost], 0))

Not sure what Denied/Approved Credits contains (number, T/F or string), but
the above would probably work with a numeric or T/F field.

HTH,