Report Layout

  • Thread starter Thread starter trainsteve
  • Start date Start date
T

trainsteve

I have a database table that has the following columns:
PicDescription - Text type
Picture - Attachment type

I now want to create a report that looks like the following:

pic1 pic 2 pic 3 pic 4
Description1
Description2
Description3
Description4


I can either get the pictures the way I want them, put then the description
is wrong, or I can get the description correct, but then the pics are wrong.

How do I get the report to look the way I want. Thanks
 
Apparently you want the pictures to display across and the descriptions to
display vertically under the pictures.

I would expect you could use a multi-column subreport in a header section to
get the pictures across. Then just add the descriptions in the detail section
of the main report.
 
This sort of works, but it wants to put every picture in the header, not just
limit it to 4 pictures.

And I need it to the report that looks like the following on a single page:

pic1 pic 2 pic 3 pic 4
Description1
Description2
Description3
Description4

pic5 pic 6 pic 7 pic 7
Description5
Description6
Description7
Description8
 
If you want your groups of 4, then you may need to add a calculated column
in the report's record source query that assigns 1 to the first 4 records, 2
to the next 4, 3 to the next, etc. Then you might be able to group the
report by the new column and place the pictures in a group header.

Duane Hookom
MS Access MVP
 
Back
Top