Using 2 Queries in a Report

  • Thread starter Thread starter ChrisP
  • Start date Start date
C

ChrisP

I have a report which is a basic Service Bill.
This report is using a query as it's source.

I want to know if I can use 2 queries in a data report on
a particular condition because my single query doesn't
contain all the information and records that I need.

I have a header which repeats the information if there
are multiple records (of problems) for a single case.

I want to check if there are parts used in the "problem"
and ifso display their information (which would be in my
second query) in the details section.

I would appreciate any help on this matter and thanks
ahead of time,

Chris
 
Chris

As far as I know, any given report relies on a single query. That said,
there would be no reason you couldn't use a second query in a second report,
then use that second report as a sub-report in the first report. If there's
a connection between what's in the first report (query) and second, you'll
need to tell Access, so it can connect the proper records showing in the
subreport.

Sorry I can't be more explicit, but the information you provided was quite
general...
 
You can create two separated recordsets (VBA) and then loop for each one and
set each field value to textboxes in your report trhough ControlSource
property.
 
Back
Top