Eliminating unnecessary data in a report

[MIchel Khennafi]

Good morning.

I created a report in access 2002 that print monthly financial information.
I have up to 24 columns to print (2 months). I create a page split by
account number. For some account numbers, I do not have to display 24
columns, maybe 10... While for other I could display 14 columns...

Is there a possibility to create a report to print up to 24 columns for a
given account but just print 10 columns for another because there is no data
to print?

Thanks so much

Happy holidays everyone!

Michel

 

[Rick B]

You'd probably have to explain what is in the columns. and how you have
titled them. If your column headings match your field names, and the record
description runs vertically down the page, fields with no data would simply
be blank. If one record displays some columns (fields) and the next
displays different fields (column) it seems like it would be very hard to
read.

More details/specific example please.

 

[MIchel Khennafi]

Each column represent a day...

So assume I have 20 days in a month --> I will potentially have 20 columns
in my report

Now assume I only have 5 days in that month where activity occured, I would
not like to print 15 empty columns, just the 5 columns where I have had
activity.

Report page 1 : all the columsn are printed (Current report)

Account# D1 d2 d3 d4 d5 d6 d7 d8...
1 1 2 3 5

Report page 1: only the columns where I have a value are printed (Desired
result)

Account# D1 d2 d3 d7
1 1 2 3 5

 

[Rick B]

One other question....

There are 12 months in the year. How are you handling that in your current
setup? Do you only store one month of data in your database? Hopefully you
don't build a new table for every month. That would be a sure sign that you
are not normalized. Anytime a table name or field name contains data (month
names, dates, etc.) you can be sure you are going down the wrong path.

Normalizing as previously mentioned would allow you to enter as many day's
worth of data as needed since you are entering a specific date for each
account with activity on that date.