RE: Report Source
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
You could have a report and subreport combination which would pull data from
more than one query.
Also if both queries basically have the same information, you could create a
union query out of them as the source for the report.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Darlene" wrote:
Is it possible to have more than one query supply information to a report?
If so, how can this process be done?
.
Relevant Pages
- Re: Passing date range Parameter to subreport
... The query has a SQL property of: ... Then open the main report with the subreport. ... MS Access MVP ...
(microsoft.public.access.reports) - Re: Passing date range Parameter to subreport
... could you give me an idea as to how to pass a date range to the query ... This would rarely be used in a report. ... MS Access MVP ... would you expect to do with a recordset and a subreport? ...
(microsoft.public.access.reports) - Re: Passing date range Parameter to subreport
... query pulls the raw material lots used to produce the product lot (again ... I want prepare a report with the ... MS Access MVP ... Then open the main report with the subreport. ...
(microsoft.public.access.reports) - Re: Passing date range Parameter to subreport
... desired query string. ... properties of the report or what. ... startdate and enddate" to a subreport. ... <MS ACCESS MVP> ...
(microsoft.public.access.reports) - Re: how to select parameter in subreport when main report is opene
... Set the LinkMasterFields property of the subreport control to ... Use this query as the subreport's RecordSource property: ... number and the main is showing the data for the same drawing the revision ... Is the main report showing the data for a single drawing number? ...
(microsoft.public.access.reports) |
|
