Re: user prompts

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 12/29/04

Next message: MarkD: "Q: Can't get crosstab query to work right"
Previous message: Steve Schapel: "Re: how do you do a query, which queries for a latest revision?"
In reply to: Lauren B.: "user prompts"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 30 Dec 2004 07:19:06 +1300

Lauren

If you enter something within []s in the Criteria row of the query
design grid, the user will be prompted accordingly, and whatever they
enter in response to the prompt will be used as a selection criteria on
that column. This is called a Parameter Query. If you mean that the
start date and end date criteria will be applied to the same field in
the query, maybe you need something like this...
Between [Start date...] And [End date...]

-- 
Steve Schapel, Microsoft Access MVP
Lauren B. wrote:
> How can I write a query so that the user receives two prompts-- one asking
> for a start date and one asking for an end date?
> 
> Thank you
> 
>

Next message: MarkD: "Q: Can't get crosstab query to work right"
Previous message: Steve Schapel: "Re: how do you do a query, which queries for a latest revision?"
In reply to: Lauren B.: "user prompts"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Dont prompt for criteria
... prompt for Date info, and in that case, NOT prompt for ClientID -- I don't ... criteria, and point the query to the form to get the criteria. ...
(microsoft.public.access.queries)
Re: Access 2000 Query using "Between Operator"
... Post the SQL String of your Query. ... Van T. Dinh ... I would like to thank you for your response. ... >>> have tried enclosing the Prompt field with a Val ...
(microsoft.public.access.queries)
Re: Criteria prompts
... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
(microsoft.public.access.reports)
Re: Criteria prompts
... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
(microsoft.public.access.reports)
RE: Filtering a subform using many combo boxes
... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... YES for all of the combo boxes.) ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
(microsoft.public.access.forms)