|
|
|
|
|
|
|
|
|
|
| |
Doing research on a similar problem. Not too clear on what is meant by the
statement "Check the Sorting and Grouping dialog." What need to be done in
the dialog?
In my case, I have created 4 groups. for the sake of argument, let's call
them grp1, grp2, grp3, grp4. They are not based on any data elements in the
tables. When I run the report, I receive the enter parameter input box for
each of these. How do I turn these off?
"Duane Hookom" wrote:
> Check the Sorting and Grouping dialog.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Eric Rodriguez" <Eric Rodriguez@discussions.microsoft.com> wrote in message
> news:1D71CA53-1CA2-41D1-BBA2-8823FF3832BD@microsoft.com...
> >I have a report that used to draw from Query A. One of the fields in the
> > report, "Nominator," got its information from Query A.
> >
> > I've removed that field and changed the underlying query to Query B. But,
> > when I try to open the report, a pop-up comes up that says "Enter
> > Parameter
> > Value" and says "Nominator." The thing is, the report is now drawing upon
> > Query B, there is no "Nominator" field in Query B and there is no
> > "Nominator"
> > field in the report. Can somebody help? Thanks.
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
The Sorting and Grouping dialog is opened by View->Sorting and Grouping. If
you want to remove these, click the selector button to the left of the
expression and press the delete key.
--
Duane Hookom
MS Access MVP
"Andy Dorph" <AndyDorph@discussions.microsoft.com> wrote in message
news:4B08A7BA-F5C7-42A8-8A47-9C04FA509488@microsoft.com...
> Doing research on a similar problem. Not too clear on what is meant by
> the
> statement "Check the Sorting and Grouping dialog." What need to be done
> in
> the dialog?
>
> In my case, I have created 4 groups. for the sake of argument, let's call
> them grp1, grp2, grp3, grp4. They are not based on any data elements in
> the
> tables. When I run the report, I receive the enter parameter input box
> for
> each of these. How do I turn these off?
>
> "Duane Hookom" wrote:
>
>> Check the Sorting and Grouping dialog.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Eric Rodriguez" <Eric Rodriguez@discussions.microsoft.com> wrote in
>> message
>> news:1D71CA53-1CA2-41D1-BBA2-8823FF3832BD@microsoft.com...
>> >I have a report that used to draw from Query A. One of the fields in
>> >the
>> > report, "Nominator," got its information from Query A.
>> >
>> > I've removed that field and changed the underlying query to Query B.
>> > But,
>> > when I try to open the report, a pop-up comes up that says "Enter
>> > Parameter
>> > Value" and says "Nominator." The thing is, the report is now drawing
>> > upon
>> > Query B, there is no "Nominator" field in Query B and there is no
>> > "Nominator"
>> > field in the report. Can somebody help? Thanks.
>>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Removing the grouping is not an option for me. Is there some way I can
programmatically override the request for the parameters?
Thanks
"Duane Hookom" wrote:
> The Sorting and Grouping dialog is opened by View->Sorting and Grouping. If
> you want to remove these, click the selector button to the left of the
> expression and press the delete key.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Andy Dorph" <AndyDorph@discussions.microsoft.com> wrote in message
> news:4B08A7BA-F5C7-42A8-8A47-9C04FA509488@microsoft.com...
> > Doing research on a similar problem. Not too clear on what is meant by
> > the
> > statement "Check the Sorting and Grouping dialog." What need to be done
> > in
> > the dialog?
> >
> > In my case, I have created 4 groups. for the sake of argument, let's call
> > them grp1, grp2, grp3, grp4. They are not based on any data elements in
> > the
> > tables. When I run the report, I receive the enter parameter input box
> > for
> > each of these. How do I turn these off?
> >
> > "Duane Hookom" wrote:
> >
> >> Check the Sorting and Grouping dialog.
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >> --
> >>
> >> "Eric Rodriguez" <Eric Rodriguez@discussions.microsoft.com> wrote in
> >> message
> >> news:1D71CA53-1CA2-41D1-BBA2-8823FF3832BD@microsoft.com...
> >> >I have a report that used to draw from Query A. One of the fields in
> >> >the
> >> > report, "Nominator," got its information from Query A.
> >> >
> >> > I've removed that field and changed the underlying query to Query B.
> >> > But,
> >> > when I try to open the report, a pop-up comes up that says "Enter
> >> > Parameter
> >> > Value" and says "Nominator." The thing is, the report is now drawing
> >> > upon
> >> > Query B, there is no "Nominator" field in Query B and there is no
> >> > "Nominator"
> >> > field in the report. Can somebody help? Thanks.
> >>
> >>
> >>
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
It isn't clear what is causing the parameters and why. If they are coming
from expression entered into the sorting and grouping then either delete
them or suggest why you won't delete them.
--
Duane Hookom
MS Access MVP
--
"Andy Dorph" <AndyDorph@discussions.microsoft.com> wrote in message
news:57F6F05E-AAAA-41FF-B906-F27C7DB9F4EE@microsoft.com...
> Removing the grouping is not an option for me. Is there some way I can
> programmatically override the request for the parameters?
>
> Thanks
>
> "Duane Hookom" wrote:
>
>> The Sorting and Grouping dialog is opened by View->Sorting and Grouping.
>> If
>> you want to remove these, click the selector button to the left of the
>> expression and press the delete key.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "Andy Dorph" <AndyDorph@discussions.microsoft.com> wrote in message
>> news:4B08A7BA-F5C7-42A8-8A47-9C04FA509488@microsoft.com...
>> > Doing research on a similar problem. Not too clear on what is meant by
>> > the
>> > statement "Check the Sorting and Grouping dialog." What need to be
>> > done
>> > in
>> > the dialog?
>> >
>> > In my case, I have created 4 groups. for the sake of argument, let's
>> > call
>> > them grp1, grp2, grp3, grp4. They are not based on any data elements
>> > in
>> > the
>> > tables. When I run the report, I receive the enter parameter input box
>> > for
>> > each of these. How do I turn these off?
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> Check the Sorting and Grouping dialog.
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >> --
>> >>
>> >> "Eric Rodriguez" <Eric Rodriguez@discussions.microsoft.com> wrote in
>> >> message
>> >> news:1D71CA53-1CA2-41D1-BBA2-8823FF3832BD@microsoft.com...
>> >> >I have a report that used to draw from Query A. One of the fields in
>> >> >the
>> >> > report, "Nominator," got its information from Query A.
>> >> >
>> >> > I've removed that field and changed the underlying query to Query B.
>> >> > But,
>> >> > when I try to open the report, a pop-up comes up that says "Enter
>> >> > Parameter
>> >> > Value" and says "Nominator." The thing is, the report is now
>> >> > drawing
>> >> > upon
>> >> > Query B, there is no "Nominator" field in Query B and there is no
>> >> > "Nominator"
>> >> > field in the report. Can somebody help? Thanks.
>> >>
>> >>
>> >>
>>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies