Refreshing a Field List in Report

T

Teri

I just added a new column to a query and saved it. When
I open the report that is based on the query, the new
column doesn't appear in the field list. How can I make
this happen?
 
M

Michel Walsh

Hi,

The report is probably bind (record source) to a fixed SQL string, "SELECT
f1, f2, f3 FROM myQuery", rather than to "myQuery".



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
New Bug in Track Changes in Word 365 0
Excel does not accept text format! 0
Formatting Rule: Diplay Section based on Selection in another section 0
Report Group Footer DLookUp 0
Mail Merge Directory Conditional Page Break 0
Access 2002 change report header text 0
Calculate the median value before a specified list 0

Top