Variable number of photos - help!

[paddleman44]

Good day everyone.

Here is my problem. I need to create a report that will display photos.

The problem is that the number of photos to display for each site varies...some sites have 4, some may have 9.

In the report, I want to have only 4 image boxes if there are 4 photos, i.e the same number of boxes as photos (no blanks).

Can this be done, and if so, any suggestions would be greatly appreciated.

Thanks.

DJ

 

[Malcy]

Umm its a bit ugly but you could devise a series of reports - with one frame, two frames, three frames etc. Then use a DCount to identify number of pictures to go into the report and then a SelectCase to print the correct report so that if the DCount is 3 it uses the report with three frames.
Would that help?