Multi-Formats (column) per page

  • Thread starter Thread starter Eric G
  • Start date Start date
E

Eric G

I have a report (four fields) based on a query.
The report is set up to print two columns if there is enough data
(more than 32 records). 64 records in total will fit the page.
With this setup I maximize the amount of data that can be displayed on
one page.

I would like to know how I could go about doing the following.
For some records, occasionally there is data in a field (currently not
being queried or displayed) that we'd like to see in the report.

How can I set up the report so that IF there is data in this '5th
field':
1. It is displayed, in sorted order, IF there are =<32 records in the
report?
2. It is displayed at the top of the list, IF there are >32 records in
the report?

Because the report is designed for two columns, this would mean
over-riding the two columns to one column for 1. above, and for 2.
above, change to one column for the first records that have a 5th
field, and then changing back to two columns below the '5th field'
record entries.

I hope I've made myself clear.
I'm assuming/hoping that Access is powerful enough to do something
like this.

Thanks! Eric
 
Eric:

you've outlined a tall order for a conditionally changing report layout.
You could spend hours getting it to work. the better solution would be to
create two versions of your report, one in the columnar format and one with
out. Then, before outputting your report, run a query that replicates the
data in the report but looks to see if there is data in the 5th field and
also counts how many records there are. Then choose which report to output
based on that evaluation. Much must faster and easier.
 
Hi Steve,

Ahhh.... That's a great solution!
You are right, it's much easier to implement it this way.
Thanks very much for your help.

Eric
 
I was looking for info on how to get 3 columns of
information to print on one page (ex Telephone list with
name ext room name ext room name ext room

with the last two sections a contiuation alphabetically.
Could you please let me know how you were able to set up
your report to print your two columns if over 32
records???

Kelly (please pretty please with Ketchup on top!!!!
 
Back
Top