Microsoft Access Form Asks Report Parameter Again
I don't see anywhere that you lot are using
[For which Qtr]
as a parameter prompt. Are you using it in one or more of the queries that you are referring to in this query? Practice you have the Verbal same parameter declared in the other query (or queries) that employ it? And is it assail the CRITERIA line of one, or more than, of those queries? Just declaring information technology a parameter isn't the whole operation.
-----
Microsoft Admission MVP 2008, 2009, 2011
If a mail service was helpful click the FOUND THIS HELPFUL link
Was this reply helpful?
That's odd: you're defining a parameter, but not using it. That does nil at all to the query. Normally y'all would accept a criterion in a WHERE clause, such as
WHERE [Qtr] = [For which Qtr]
in the query.
To avoid multiple prompts - in fact to avert prompts completely! - y'all can create a little unbound form frmCrit with a textbox, txtQtr say; and apply a benchmark of
=[FOrms]![frmCrit]![txtQtr]
Open the Form commencement, enter the quarter, so open the Course or Report based on your query (you wouldn't usually open a query datasheet to user view, though that's certainly possible). It'southward convenient to put a control button on frmCrit to open the desired study (or whatever).
John W. Vinson/MVP
Was this reply helpful?
The only parameter I run into is[For which Qtr] and it is not used in the SQL.
Build a footling, test a footling
Was this reply helpful?
Offset, as the others have mentioned, adding a parameter to the parameters list doesn't make use of the parameter. You have to assigned the parameter in a WHERE clause.
Merely that doesn't actually reply your question. Every time a query is referenced, any parameters volition be prompted for. So if a query is a sub-query that is called by other queries, each time its called the parameter will be prompted for.
This is one of the reasons I well-nigh never apply parameter prompt queries. Instead I prefer to enter my parameters using a form and and so. referencing them equally the criteria. For example you could have a grade with an Option group to select which Quarter. In your query you would fix the criteria for the Quarter column to:
=Forms!formname!optQuarter
where formname is the proper noun of your form and optQuarter the proper noun of the Option grouping. Then each time the query is called it will look to the course and not prompt you.
Hope this helps,
Scott<>
Web log: http://scottgem.wordpress.com
Microsoft Admission MVP since 2007
1 person found this reply helpful
·
Was this reply helpful?
First, as the others take mentioned, adding a parameter to the parameters list doesn't brand employ of the parameter. You lot accept to assigned the parameter in a WHERE clause.Simply that doesn't really answer your question. Every time a query is referenced, any parameters will be prompted for. So if a query is a sub-query that is called by other queries, each fourth dimension its called the parameter will exist prompted for.
This is i of the reasons I almost never utilize parameter prompt queries. Instead I prefer to enter my parameters using a form and and so. referencing them as the criteria. For example you could take a class with an Option group to select which Quarter. In your query y'all would gear up the criteria for the Quarter column to:
=Forms!formname!optQuarterwhere formname is the name of your form and optQuarter the name of the Option group. Then each time the query is called it volition look to the form and not prompt you lot.
Not bad answer - you earned a fish. lol
-----
Microsoft Access MVP 2008, 2009, 2011
If a mail service was helpful click the FOUND THIS HELPFUL link
Was this reply helpful?
Cheers for your input, I volition try this and report dorsum.
JD
Was this reply helpful?
Adept Morning time Scott,
I would like to effort your suggestion but do not know how to ready a form with an selection group.
The parameters which I wish to set are for; What Fiscal Qtr? and What Fiscal Year? (yy).
The Fiscal quarter field and Fiscal twelvemonth field are calculated query fields based on a table field [WStats].[WDate].
The summary query that I am creating is for a single quarter in a fiscal yr. The underlying queries select a singled-out group of records from the table based on a Max query on the [WDate] field. This pick of singled-out records is then joined with the matching data based on a unique identifier with the table [WStats]. The final summary query is a totals query based on the above mentioned resutlts.
I am currently inserting my parameters into the intial Max query. This query has iv fields, tow of which are the parameter fields for FQtr & FYr.
To avoid the multiple asking for the query paramters, I would like to prepare your form solution.
Could you ship me an example of a parameter course?
Give thanks you lot....
JD
Was this reply helpful?
Adept Morning Scott,
I would like to try your suggestion simply do not know how to set up a form with an option group.
Could you send me an example of a parameter form?Thank yous....
JD
The key to inputting parameters through a class is the referencing syntax:
=forms!formname!controlname
You employ the Option Group wizard to set a group on a form. To exist more specific I demand to know how you shop FQtr and FYr.
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007
Was this reply helpful?
Here is the SQL where I starting time use the formulae for the two parameters. Here it is used to select a singled-out grouping of records from my many table where individual issue records are stored.
In other subsequent queries I use the same formulae to create calculated query fields for summaries. We only summarize in queries and forms, we do not produce paper reports. If nosotros need a paper reference we simply print the course for the desired record.
SQL
PARAMETERS [For What Fiscal Quarter?] IEEEDouble, [For What Fiscal Twelvemonth? (yy)] IEEEDouble;
SELECT WStats.SNum, Max(WStats.WDate) Every bit MaxOfWDate, Format(DateAdd("m",-three,[WDate]),"q") Equally FQtr, Format(DateAdd("m",-three,[WStats]![WDate]),"yy") As FYr
FROM WStats
GROUP BY WStats.SNum, Format(DateAdd("yard",-3,[WDate]),"q"), Format(DateAdd("m",-3,[WStats]![WDate]),"yy")
HAVING (((Format(DateAdd("one thousand",-3,[WDate]),"q"))=[For What Fiscal Quarter?]) AND ((Format(DateAdd("chiliad",-3,[WStats]![WDate]),"yy"))=[For What Financial Year? (yy)]));
I will try and setup a grade using the wizard after dejeuner.
Thanks.
JD
Was this respond helpful?
Parameters for a crosstab have to be declared in the crosstab even if non used within information technology merely in a query that feeds the crosstab.
Build a piffling, test a little
Was this respond helpful?
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/access-2010-ask-for-same-query-parameter-several/75505225-61ac-4cd4-a5b6-93c414d72689
0 Response to "Microsoft Access Form Asks Report Parameter Again"
Post a Comment