Re: Using one report for different queries

Ok. It sounds like your first one, All Members is the most
comprehensive list. So basically, the other queries you made are All
Members query but with some criteria done to it to get a smaller list.
Correct?

You should be able to take the All Members query and make that the data
source of your report. Now when the report is opened, you pass it some
criteria depending on which list you want as the other person's post
suggested.


john wrote:
The differences between the queries are the selection criteria. For
instance:
1. All members
2. This year's new members
3. Members of a specific zipcode area
4. Female members
5. This year's male members
etc.
I don't know how to put this in one query or report.
john

"Jeff L" <jleckrone@xxxxxxxxxxx> schreef in bericht
news:1157051062.821619.291120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
What is different about your 10 queries? It seems to me like you
should be able to do all of this with one query, one report, and
perhaps a filter.



john wrote:
I have a report to print envelopes. The report is based on a query. Now I
need to make 10 more queries to make different selections of addresses.
Every query has the same output fields as the already existing query. I
know
I can copy the report and base it on another query but then I would have
to
make 10 extra reports. How can I use just one report for all of the
queries?
At the moment I use the button wizard in my forms to make buttons that
start
the particular reports. Resulting code looks like this:

Private Sub Knop34_Click()
On Error GoTo Err_Knop29_Click

Dim stDocName As String

stDocName = "Alle leden per Bezorgcategorie"
DoCmd.OpenReport stDocName, acPreview

Exit_Knop29_Click:
Exit Sub

Can I perhaps add some code that points which query the report should be
based on?
Thanks,
john


.

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: Membership database updates
    ... of members who joined in that month or year. ... You can put a text box in your report header and type ... Next to Query Name choose the name of your first query in Step 4 from ... in the UpdateTo line under the RemovedDate field - the RemovedDate will ...
    (microsoft.public.access.tablesdbdesign)