Parameters in Report two

[Lee]

Hello,

I am a beginner in Access. I was wondering step by step if someone could
help me?

I made a report that is based off of a query. The query has in total 15
queries and a main query that sets the parameter. So the parameters carry
over the 15 queries.
In my criteria field I set the parameters in the main query as followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of the 15
queries. When running the report it ask me to input the values three times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat the
values again for another 4 times before the report opens. Is there a way to
bypass all this and input the values just once so it can immediately populate
my report?

Remind you, when you enter one of the criteria's it will just return that
criteria’s value. If you input all three, it will return the population, and
so on. But I just want it once.

Thank you.

 

[Rick B]

In your report, did you name the parameters exactly like in the queries?
You should have them as [Enter CAT], [Enter M&E], etc.

If the parameters in your report match your criteria in your query, you
should not be prompted more than once.

 

[Lee]

the problem is that the report has a subreport attached to it. So it is
prompting me once for the report, then additional 3 times for the sub report.

So i tried to see what was causing the problem. I went to the queries and
it prompted me once, so that is fine.

Then I went to the subreport and it prompted me once, which was fine,

But where the main report that pulls everything together it prompts me four
times. I can't seem to understand why.

Is there a way for a form to handle the parameters as a filter to only input
once and then preview the report.

In your report, did you name the parameters exactly like in the queries?
You should have them as [Enter CAT], [Enter M&E], etc.

If the parameters in your report match your criteria in your query, you
should not be prompted more than once.

--
Rick B

Hello,

I am a beginner in Access. I was wondering step by step if someone could
help me?

I made a report that is based off of a query. The query has in total 15
queries and a main query that sets the parameter. So the parameters carry
over the 15 queries.
In my criteria field I set the parameters in the main query as followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of the 15
queries. When running the report it ask me to input the values three
times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat the
values again for another 4 times before the report opens. Is there a way
to
bypass all this and input the values just once so it can immediately
populate
my report?

Remind you, when you enter one of the criteria's it will just return that
criteria's value. If you input all three, it will return the population,
and
so on. But I just want it once.

Thank you.

 

[Rick B]

Yes. That is probably what you want to do. Build a "parameter form" and
let the users make the entries there, then pull from that form in your
queries and reports. On that form, have a button that runs your report.
DON'T close the form until the reports are produced.

Do a search and you will find previous posts on "parameter forms" that will
go into some great detail.


--
Rick B

the problem is that the report has a subreport attached to it. So it is
prompting me once for the report, then additional 3 times for the sub
report.

So i tried to see what was causing the problem. I went to the queries and
it prompted me once, so that is fine.

Then I went to the subreport and it prompted me once, which was fine,

But where the main report that pulls everything together it prompts me
four
times. I can't seem to understand why.

Is there a way for a form to handle the parameters as a filter to only
input
once and then preview the report.

In your report, did you name the parameters exactly like in the queries?
You should have them as [Enter CAT], [Enter M&E], etc.

If the parameters in your report match your criteria in your query, you
should not be prompted more than once.

--
Rick B

Hello,

I am a beginner in Access. I was wondering step by step if someone
could
help me?

I made a report that is based off of a query. The query has in total
15
queries and a main query that sets the parameter. So the parameters
carry
over the 15 queries.
In my criteria field I set the parameters in the main query as
followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of the
15
queries. When running the report it ask me to input the values three
times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat the
values again for another 4 times before the report opens. Is there a
way
to
bypass all this and input the values just once so it can immediately
populate
my report?

Remind you, when you enter one of the criteria's it will just return
that
criteria's value. If you input all three, it will return the
population,
and
so on. But I just want it once.

Thank you.

 

[Lee]

I am not really sure how to build that according to my situation. Because
most of them talk about date ranges. Can you give me some help on the query
and the form part. Thanks.

Yes. That is probably what you want to do. Build a "parameter form" and
let the users make the entries there, then pull from that form in your
queries and reports. On that form, have a button that runs your report.
DON'T close the form until the reports are produced.

Do a search and you will find previous posts on "parameter forms" that will
go into some great detail.


--
Rick B

the problem is that the report has a subreport attached to it. So it is
prompting me once for the report, then additional 3 times for the sub
report.

So i tried to see what was causing the problem. I went to the queries and
it prompted me once, so that is fine.

Then I went to the subreport and it prompted me once, which was fine,

But where the main report that pulls everything together it prompts me
four
times. I can't seem to understand why.

Is there a way for a form to handle the parameters as a filter to only
input
once and then preview the report.

In your report, did you name the parameters exactly like in the queries?
You should have them as [Enter CAT], [Enter M&E], etc.

If the parameters in your report match your criteria in your query, you
should not be prompted more than once.

--
Rick B



Hello,

I am a beginner in Access. I was wondering step by step if someone
could
help me?

I made a report that is based off of a query. The query has in total
15
queries and a main query that sets the parameter. So the parameters
carry
over the 15 queries.
In my criteria field I set the parameters in the main query as
followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of the
15
queries. When running the report it ask me to input the values three
times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat the
values again for another 4 times before the report opens. Is there a
way
to
bypass all this and input the values just once so it can immediately
populate
my report?

Remind you, when you enter one of the criteria's it will just return
that
criteria's value. If you input all three, it will return the
population,
and
so on. But I just want it once.

Thank you.

 

[Rick B]

To use data from a form as your qurey parameter, you'd do something like...
=Forms![MySearchFormName]![MySearchFieldName]





If you have a date range, you might see something like...
Between Forms![MySearchFormName]![StartDateFieldName] and
Forms![MySearchFormName]![EndDateFieldName]


To find records prior to a date entered in your form...
< Forms![MySearchFormName]![SomeDateFieldName]


--
Rick B

I am not really sure how to build that according to my situation. Because
most of them talk about date ranges. Can you give me some help on the
query
and the form part. Thanks.

Yes. That is probably what you want to do. Build a "parameter form" and
let the users make the entries there, then pull from that form in your
queries and reports. On that form, have a button that runs your report.
DON'T close the form until the reports are produced.

Do a search and you will find previous posts on "parameter forms" that
will
go into some great detail.


--
Rick B

the problem is that the report has a subreport attached to it. So it
is
prompting me once for the report, then additional 3 times for the sub
report.

So i tried to see what was causing the problem. I went to the queries
and
it prompted me once, so that is fine.

Then I went to the subreport and it prompted me once, which was fine,

But where the main report that pulls everything together it prompts me
four
times. I can't seem to understand why.

Is there a way for a form to handle the parameters as a filter to only
input
once and then preview the report.

:

In your report, did you name the parameters exactly like in the
queries?
You should have them as [Enter CAT], [Enter M&E], etc.

If the parameters in your report match your criteria in your query,
you
should not be prompted more than once.

--
Rick B



Hello,

I am a beginner in Access. I was wondering step by step if someone
could
help me?

I made a report that is based off of a query. The query has in
total
15
queries and a main query that sets the parameter. So the parameters
carry
over the 15 queries.
In my criteria field I set the parameters in the main query as
followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of
the
15
queries. When running the report it ask me to input the values
three
times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat
the
values again for another 4 times before the report opens. Is there
a
way
to
bypass all this and input the values just once so it can immediately
populate
my report?

Remind you, when you enter one of the criteria's it will just return
that
criteria's value. If you input all three, it will return the
population,
and
so on. But I just want it once.

Thank you.