Do you need only photoa1 for each record, or do you need photoa1 for some and photob1 for others?
If you need the photoa1 only, take photob1 out of the query the report is based on. If your report is based on the table, write a query without photob1, and base your report on that query.
If you...