multiple record sources

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: BAZ (BAZ_at_discussions.microsoft.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 12:47:05 -0800

I want to create a report that pulls from 3 different queries. It really
doesn't work to pull the queries together to make 1 big query because the
data isn't related that way. Do you know how to indicate that you want more
than one record source? I tried to follow the help, but when I choose a
field from another query then it doesn't recognize one of the other fields. 

-- 
Thanks for your help!

Relevant Pages

  • Re: Same Parameters in all sub reports
    ... something wrong between the form and the query. ... It didn't for my regular queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ...
    (microsoft.public.access.reports)
  • Re: Queries are driving me nuts!
    ... Then tell us how you want your queries and/or reports to appear. ... >>> name the report was totally blank. ... I then ran each query separately to ... >>> taught every lesson yet. ...
    (microsoft.public.access.queries)
  • saved queries based on other saved queries vs. one big query in a forms module using DAO
    ... domain aggregate functions to do what you want to do, ... rather than having nested queries. ... Calculating the summary values in the query has some ... calculating the values in the report ...
    (microsoft.public.access.queries)
  • Re: Help with query
    ... such as the definitions of the Queries you refer to, and sample records from the Tables. ... In addition to the sample records I mentioned in each of the Tables used by your Queries, I suggest that you also show an example datasheet that shows the results you'd like your Query to display, based on those sample records. ... I currently have a statement report that has a subreport of all linked to the ... the enterprise rules are payment 30 days from end of month.... ...
    (microsoft.public.access.queries)
  • RE: More line number questions
    ... "Barry" wrote: ... When we linked the original 2 queries and added all the records from ... mimic the old paper report, ... Yes indeed I did change the link in the query to a Left Join. ...
    (microsoft.public.access.reports)