I have a table with 3 columns Totals, SalesOffice and Type. Type contains 4
different entries Cash Contribution, Cash Distribution, Security
Contribution and Security Distribution. I want to set the report up like
this:
SalesOffice Contributions Distributions Net
Cash
Securities
I can't figure out how to get it to display correctly. I've tried using 4
labels with
=IIF([Type]="Cash Contribution","[Totals],"")
=IIF([Type]="Cash Distribution","[Totals],"")
etc but it's just showing #Error when I run the report. Any insight would be
highly appreciated. I wrote a stored proc on a SQL 2005 server to create the
output table so I can modify it if needed to make this easier. I'm working
with Access 2003.
TIA
-Matt
|
Similar Threads
