Using 2 Queries in a Report

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
 
J

Jeff Boyce

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...
 
K

kareka

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.
 
Top