Asking for old field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...

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 address removed) and (e-mail address 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.
 
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...
 
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...
Click to expand...

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 address removed) and (e-mail address 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.
 
Thanks, I found it that way, it was actually defined in 'sorting and
grouping' as a sort field
 
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 address removed) and (e-mail address removed)
 
Back
Top