Change in underlying query

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

Guest

I have a report which is based off a query. Now I tweaked the query a bit but
those changes dont reflect in the report. I saved the query and already tried
closing and saving both the query and report. How can the report recognize
the underlying query changes
 
Let's say you only changed the name of a single field in the query, from
"MyFirstField" to "MyNewField". Your report was created to use the data it
found in the query. It (your report) is still looking for a field named
"MyFirstField", but the query no longer has a field with that name.

Open your report in design mode and look for the control formerly displaying
"MyFirstField" and change the Control Source to "MyNewField".

(You will need to substitute the field names you are using...)
 
You did not say what you tweaked. If you changed sorts and your report has
grouping and sorting it will over-ride what is in the query.
 
Back
Top