Connecting Tech Pros Worldwide Help | Site Map

A report with prompts, but without a query...Possible? Clarification Please.

tom@nvwisp.com
Guest
 
Posts: n/a
#1: Feb 10 '06
Is it possible to have a report with prompts/parameters, but without an
underlying query? I've seen varying posts related to this, but I'm not
seeing a concete answer. As I understand it, to make a report with
prompts, the parameters (e.g., start and end dates) must be first
defined in the report's underlying query. Thus, I am concluding:

A) The Table-Report construct (without an explicit underlying query) is
for basic retrieve-all-records reports.

B) The Table-Query-Report construct allows for limited record
retrieval.

Am I on track here?

Thanks in advance to those wiser than me!

Lyle Fairfield
Guest
 
Posts: n/a
#2: Feb 10 '06

re: A report with prompts, but without a query...Possible? Clarification Please.


DoCmd.OpenReport "Customers", acViewPreview, , "CustomerID LIKE
[Whatever]"

works (tested only in Access 2003) for a "Table-Report construct"; it
prompts for [Whatever].

If the report is already open the where condition will be ignored.

Closed Thread