Report Layout

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
 
D

Duane Hookom

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.
 
T

trainsteve

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
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top