First post (I think)
I have a db with a bunch of records... there is an attachment field in the data table. Only images are attached to these records.
I created a query to display the attachments in a report. I grouped the results by record ID.
Here is where the problem starts. When the report is displayed, if there are more than one image attachments in the record (lets say there are 5), the report will display all five but the image that is displayed will be the first image only 5 times. Even though all the other information pertaining to each picture is correct... it doesn't show all 5 images.
What the report looks like... as you can see... record 184 has 4 attached images with unique file names but the image from the first one just repeats.
Here is the query in case it means anything. (some of the items in the query aren't shown in the screenshot of the report above)
Any idea why it doesn't show each attached image to go with each filename?