Report needed with limited columns

[p2andr]

Hello,

I need to build a report in Access 2007 to include the client name & info (from one table) and the accounting transactions (another table) for that client but I don't want to include a column if there is no activity (zero dollars) in that column (field).

I have built a query to pull the appropriate fields but I can't figure out how to limit the columns on the report to just transactions that have values.

Thank you.

Robin

 

[MajP]

Sounds to me that your database is not normalized, which makes this difficult. There should not be different fields for the same type of data. Can you provide the table structure, relevant fields, and possibly sample data and desired output? Cannot really help without that information.

 

[Hap007]

Hi Robin

Sounds like you should use a group header footer for client info.

Then, you can place the accounting transactions in the detail area or in a sub report.

You could use field or conditional formating to blank the accounting transaction total when zero.

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121