My report is based off a query. I tweaked the query to change the name of one
field. I have made the corresponding change in the report to that field.
There is no other place in the report that field is called for. Yet when I
open the report in print preview, I am prompted for value of that old field.
I have closed and saved and yet the same result. Please advise...

Hi, neeraj.

> There is no other place in the report that field is called for. Yet when I
> open the report in print preview, I am prompted for value of that old field.

Open the report in Design View and then open the Sorting and Grouping dialog
window. In the "Field/Expression" column, look for the previous name of your
field. If you find it, change it to the field's new name.

If it isn't in the report, check the query. Open the query in Design View
and right-click in the upper pane (where the tables are) and select
"Properties..." on the pop-up menu. Look at the "Filter" and "Order By"
Properties for the previous name of your field. If you find it, change it to
the field's new name.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (E-Mail Removed) and (E-Mail Removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


"neeraj" wrote:

> My report is based off a query. I tweaked the query to change the name of one
> field. I have made the corresponding change in the report to that field.
> There is no other place in the report that field is called for. Yet when I
> open the report in print preview, I am prompted for value of that old field.
> I have closed and saved and yet the same result. Please advise...

I didn't find that field there also; actually both these properties were
blank. Moreover, the query when run on its own, doesn't prompt for that
field...only the report wants it...

"'69 Camaro" wrote:

> Hi, neeraj.
>
> > There is no other place in the report that field is called for. Yet when I
> > open the report in print preview, I am prompted for value of that old field.
>
> Open the report in Design View and then open the Sorting and Grouping dialog
> window. In the "Field/Expression" column, look for the previous name of your
> field. If you find it, change it to the field's new name.
>
> If it isn't in the report, check the query. Open the query in Design View
> and right-click in the upper pane (where the tables are) and select
> "Properties..." on the pop-up menu. Look at the "Filter" and "Order By"
> Properties for the previous name of your field. If you find it, change it to
> the field's new name.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
> Beware to those who use munged addresses: known newsgroup E-mail harvesters
> for spammers are (E-Mail Removed) and (E-Mail Removed)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions. Remember that questions
> answered the quickest are often from those who have a history of rewarding
> the contributors who have taken the time to answer questions correctly.
>
>
> "neeraj" wrote:
>
> > My report is based off a query. I tweaked the query to change the name of one
> > field. I have made the corresponding change in the report to that field.
> > There is no other place in the report that field is called for. Yet when I
> > open the report in print preview, I am prompted for value of that old field.
> > I have closed and saved and yet the same result. Please advise...

Hi, neeraj.

> I didn't find that field there also; actually both these properties were
> blank. Moreover, the query when run on its own, doesn't prompt for that
> field...only the report wants it...

Then the report is hiding the previous name of the field somewhere. To find
it, use the built-in Documenter wizard to document the report, making sure
that the "Options" selected include everything but the "Permissions by Users
and Group" item, and then export the results to an Excel spreadsheet. Run
"Find" on your field's previous name. You'll find it.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (E-Mail Removed) and (E-Mail Removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


"neeraj" wrote:

> I didn't find that field there also; actually both these properties were
> blank. Moreover, the query when run on its own, doesn't prompt for that
> field...only the report wants it...
>
> "'69 Camaro" wrote:
>
> > Hi, neeraj.
> >
> > > There is no other place in the report that field is called for. Yet when I
> > > open the report in print preview, I am prompted for value of that old field.
> >
> > Open the report in Design View and then open the Sorting and Grouping dialog
> > window. In the "Field/Expression" column, look for the previous name of your
> > field. If you find it, change it to the field's new name.
> >
> > If it isn't in the report, check the query. Open the query in Design View
> > and right-click in the upper pane (where the tables are) and select
> > "Properties..." on the pop-up menu. Look at the "Filter" and "Order By"
> > Properties for the previous name of your field. If you find it, change it to
> > the field's new name.
> >
> > HTH.
> >
> > Gunny
> >
> > See http://www.QBuilt.com for all your database needs.
> > See http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > will be forwarded to me.)
> > Beware to those who use munged addresses: known newsgroup E-mail harvesters
> > for spammers are (E-Mail Removed) and (E-Mail Removed)
> >
> > - - -
> > When you see correct answers to your question posted in Microsoft's Online
> > Community, please sign in to the Community and mark these posts as "Answers,"
> > so that all may benefit by filtering on "Answered questions" and quickly
> > finding the right answers to similar questions. Remember that questions
> > answered the quickest are often from those who have a history of rewarding
> > the contributors who have taken the time to answer questions correctly.
> >
> >
> > "neeraj" wrote:
> >
> > > My report is based off a query. I tweaked the query to change the name of one
> > > field. I have made the corresponding change in the report to that field.
> > > There is no other place in the report that field is called for. Yet when I
> > > open the report in print preview, I am prompted for value of that old field.
> > > I have closed and saved and yet the same result. Please advise...

Thanks, I found it that way, it was actually defined in 'sorting and
grouping' as a sort field

"'69 Camaro" wrote:

> Hi, neeraj.
>
> > I didn't find that field there also; actually both these properties were
> > blank. Moreover, the query when run on its own, doesn't prompt for that
> > field...only the report wants it...
>
> Then the report is hiding the previous name of the field somewhere. To find
> it, use the built-in Documenter wizard to document the report, making sure
> that the "Options" selected include everything but the "Permissions by Users
> and Group" item, and then export the results to an Excel spreadsheet. Run
> "Find" on your field's previous name. You'll find it.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
> Beware to those who use munged addresses: known newsgroup E-mail harvesters
> for spammers are (E-Mail Removed) and (E-Mail Removed)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions. Remember that questions
> answered the quickest are often from those who have a history of rewarding
> the contributors who have taken the time to answer questions correctly.
>
>
> "neeraj" wrote:
>
> > I didn't find that field there also; actually both these properties were
> > blank. Moreover, the query when run on its own, doesn't prompt for that
> > field...only the report wants it...
> >
> > "'69 Camaro" wrote:
> >
> > > Hi, neeraj.
> > >
> > > > There is no other place in the report that field is called for. Yet when I
> > > > open the report in print preview, I am prompted for value of that old field.
> > >
> > > Open the report in Design View and then open the Sorting and Grouping dialog
> > > window. In the "Field/Expression" column, look for the previous name of your
> > > field. If you find it, change it to the field's new name.
> > >
> > > If it isn't in the report, check the query. Open the query in Design View
> > > and right-click in the upper pane (where the tables are) and select
> > > "Properties..." on the pop-up menu. Look at the "Filter" and "Order By"
> > > Properties for the previous name of your field. If you find it, change it to
> > > the field's new name.
> > >
> > > HTH.
> > >
> > > Gunny
> > >
> > > See http://www.QBuilt.com for all your database needs.
> > > See http://www.Access.QBuilt.com for Microsoft Access tips.
> > >
> > > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > > will be forwarded to me.)
> > > Beware to those who use munged addresses: known newsgroup E-mail harvesters
> > > for spammers are (E-Mail Removed) and (E-Mail Removed)
> > >
> > > - - -
> > > When you see correct answers to your question posted in Microsoft's Online
> > > Community, please sign in to the Community and mark these posts as "Answers,"
> > > so that all may benefit by filtering on "Answered questions" and quickly
> > > finding the right answers to similar questions. Remember that questions
> > > answered the quickest are often from those who have a history of rewarding
> > > the contributors who have taken the time to answer questions correctly.
> > >
> > >
> > > "neeraj" wrote:
> > >
> > > > My report is based off a query. I tweaked the query to change the name of one
> > > > field. I have made the corresponding change in the report to that field.
> > > > There is no other place in the report that field is called for. Yet when I
> > > > open the report in print preview, I am prompted for value of that old field.
> > > > I have closed and saved and yet the same result. Please advise...

Good job. The next time you change field names in the query and the report
and then the report asks for the previous field name when you open it, the
first place you'll look is in the "Field/Expression" column in the Sorting
and Grouping dialog window, just like the rest of us.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (E-Mail Removed) and (E-Mail Removed)


"neeraj" <(E-Mail Removed)> wrote in message
news:CADDD5BC-C36A-4E85-A4FE-(E-Mail Removed)...
> Thanks, I found it that way, it was actually defined in 'sorting and
> grouping' as a sort field
>
> "'69 Camaro" wrote:
>
>> Hi, neeraj.
>>
>> > I didn't find that field there also; actually both these properties
>> > were
>> > blank. Moreover, the query when run on its own, doesn't prompt for that
>> > field...only the report wants it...
>>
>> Then the report is hiding the previous name of the field somewhere. To
>> find
>> it, use the built-in Documenter wizard to document the report, making
>> sure
>> that the "Options" selected include everything but the "Permissions by
>> Users
>> and Group" item, and then export the results to an Excel spreadsheet.
>> Run
>> "Find" on your field's previous name. You'll find it.
>>
>> HTH.
>>
>> Gunny
>>
>> See http://www.QBuilt.com for all your database needs.
>> See http://www.Access.QBuilt.com for Microsoft Access tips.
>>
>> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
>> will be forwarded to me.)
>> Beware to those who use munged addresses: known newsgroup E-mail
>> harvesters
>> for spammers are (E-Mail Removed) and (E-Mail Removed)
>>
>> - - -
>> When you see correct answers to your question posted in Microsoft's
>> Online
>> Community, please sign in to the Community and mark these posts as
>> "Answers,"
>> so that all may benefit by filtering on "Answered questions" and quickly
>> finding the right answers to similar questions. Remember that questions
>> answered the quickest are often from those who have a history of
>> rewarding
>> the contributors who have taken the time to answer questions correctly.
>>
>>
>> "neeraj" wrote:
>>
>> > I didn't find that field there also; actually both these properties
>> > were
>> > blank. Moreover, the query when run on its own, doesn't prompt for that
>> > field...only the report wants it...
>> >
>> > "'69 Camaro" wrote:
>> >
>> > > Hi, neeraj.
>> > >
>> > > > There is no other place in the report that field is called for. Yet
>> > > > when I
>> > > > open the report in print preview, I am prompted for value of that
>> > > > old field.
>> > >
>> > > Open the report in Design View and then open the Sorting and Grouping
>> > > dialog
>> > > window. In the "Field/Expression" column, look for the previous name
>> > > of your
>> > > field. If you find it, change it to the field's new name.
>> > >
>> > > If it isn't in the report, check the query. Open the query in Design
>> > > View
>> > > and right-click in the upper pane (where the tables are) and select
>> > > "Properties..." on the pop-up menu. Look at the "Filter" and "Order
>> > > By"
>> > > Properties for the previous name of your field. If you find it,
>> > > change it to
>> > > the field's new name.
>> > >
>> > > HTH.
>> > >
>> > > Gunny
>> > >
>> > > See http://www.QBuilt.com for all your database needs.
>> > > See http://www.Access.QBuilt.com for Microsoft Access tips.
>> > >
>> > > (Please remove ZERO_SPAM from my reply E-mail address, so that a
>> > > message
>> > > will be forwarded to me.)
>> > > Beware to those who use munged addresses: known newsgroup E-mail
>> > > harvesters
>> > > for spammers are (E-Mail Removed) and (E-Mail Removed)
>> > >
>> > > - - -
>> > > When you see correct answers to your question posted in Microsoft's
>> > > Online
>> > > Community, please sign in to the Community and mark these posts as
>> > > "Answers,"
>> > > so that all may benefit by filtering on "Answered questions" and
>> > > quickly
>> > > finding the right answers to similar questions. Remember that
>> > > questions
>> > > answered the quickest are often from those who have a history of
>> > > rewarding
>> > > the contributors who have taken the time to answer questions
>> > > correctly.
>> > >
>> > >
>> > > "neeraj" wrote:
>> > >
>> > > > My report is based off a query. I tweaked the query to change the
>> > > > name of one
>> > > > field. I have made the corresponding change in the report to that
>> > > > field.
>> > > > There is no other place in the report that field is called for. Yet
>> > > > when I
>> > > > open the report in print preview, I am prompted for value of that
>> > > > old field.
>> > > > I have closed and saved and yet the same result. Please advise...