You don't necessarily have to create two reports. If the structure and fields etc are the same, you can dynamically change the recordsource of the report.
Fistrly create a text box [txt_source]
then on the openreport button add the lines
Code:
dim queryresult as variant queryresult = dmax("[boxno]","[table]","[where clause the same as your query]") if isnull(queryresult)=false then dothis [forms]![form]![txt_source]="Source1" else dothat
[forms]![form]![txt_source]="Source2"
endif
Then on the report open event
Code:
if [forms]![form]![txt_source]="source1" then
me.recordsource= "SQL1"
else
me.recordsource="SQL2"
endif