Display data from two querys

[Nick]

Cage1
SELECT ALID0001.label_id, ALID0001.date, ALID0001.date, ALID0001.TIME
FROM ALID0001
GROUP BY ALID0001.label_id, ALID0001.date, ALID0001.date, ALID0001.TIME
HAVING (((ALID0001.label_id)=[Enter Carrier number]) AND
((ALID0001.date)=[enter date]));

carrierbartest
SELECT ALID0001.label_id, ALID0001.date, ALID0001.time, Cage1.date,
ALID0001.scans
FROM ALID0001, Cage1
WHERE (((ALID0001.label_id)<>[Cage1].[label_id]) AND
((ALID0001.date)=[Cage1].[date]) AND ((ALID0001.time)=[Cage1].[time]) AND
((ALID0001.scans)="07"));

I have a report that ask "Enter Carrier Number" (Cage1) and it displays the
information I need from the (carrierbartest) but it does not display the
Carrier Number from the Cage1 query. How do I get to do both? I would like it
to show the "Carrier Number" at the top of the page and the data from
carrierbartest below.

 

[SusanV]

Either create a new query from both existing queries as your recordsource
for the report, or create a subreport based on the carrierbartest query and
embed it in the report based on the Cage1 query.