Re: create a report based on 30 queries

David

So it sounds like your "30 queries" are each returning a single value.

Another approach might be to create a report that is not bound to any query,
then use controls in the report to "get" the individual values using the
DMax(), or DMin(), or DCount() functions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

<davidstevans@xxxxxxxxx> wrote in message
news:1188415709.899856.265140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Jeff Queries are like below:

SELECT Min(MailDate) FROM YourTable

What is the oldest maildate with an operator assigned to it.

SELECT Min(MailDate) FROM YourTable WHERE Operator is Not Null

What is the oldest maildate without an operator assigned to it

SELECT Max(MailDate) FROM YourTable WHERE Operator is Null

What is the oldest maildate for the current year

SELECT Min(MailDate) FROM YourTable WHERE [Year] = "07"

What is the oldest maildate for the prior years(anything that is not


SELECT Min(MailDate) FROM YourTable WHERE [Year] <> "07"

What is the oldest maildate where data in CURRENT starts with 714.

SELECT Min(MailDate) FROM YourTable WHERE [CURRENT] Like "714*"

, How many records are between 0 to 30 days with an operator.

SELECT Count(*) FROM YourTable WHERE [Days] Between 0 and 30
and
Operator is not Null



.

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: Same Parameters in all sub reports
    ... Again, I have multiple queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ... controls to provide the queries' selection criteria. ...
    (microsoft.public.access.reports)
  • Re: Sharing report formatting with other users?
    ... queries and reports reside on our in house server, ... "Jeff Boyce" wrote: ... calls a function in the middle-end that opens the report in the middle-end. ...
    (microsoft.public.access.reports)
  • Re: Sharing report formatting with other users?
    ... "Jeff Boyce" wrote: ... But I'm not clear on whether your other users want to report on the exact ... If I create this new Access .mdb file, ... to create an Access .mdb file that contains the queries and reports, ...
    (microsoft.public.access.reports)