I have a report that lists three records, four of the fields in these records are based on fields from a main table that are lookups to different queries (i.e., [pollutant code] field stores a number from a lookup that displays the code number and a description of the pollutant...only the numerical code is stored in the main table).
In the report, I display all the other information in the records from the main table, and I want the subreports to display the description that goes along with the numerical code (pollutant code, etc.).
So far, I can only get one record to return in the subreport(s) (so the subreport(s) leave out the information for the pollutant codes in the remaining two records). If this makes sense to anyone, I would love some advice on how to get the subreport to display all three pollutant codes (one from each record in the main report).
Thank You!
In the report, I display all the other information in the records from the main table, and I want the subreports to display the description that goes along with the numerical code (pollutant code, etc.).
So far, I can only get one record to return in the subreport(s) (so the subreport(s) leave out the information for the pollutant codes in the remaining two records). If this makes sense to anyone, I would love some advice on how to get the subreport to display all three pollutant codes (one from each record in the main report).
Thank You!
