Add new table field to Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vulcan - 29 Mar 2007 22:54 GMT

After I create a Report I want to go back and add a few fields to a table and
then bring those new fields into the Report. When I bring up the details list
I don't see the new fields I created. Help!

Reply to this Message

Dirk Goldgar - 29 Mar 2007 23:20 GMT

> After I create a Report I want to go back and add a few fields to a
> table and then bring those new fields into the Report. When I bring
> up the details list I don't see the new fields I created. Help!

Check the report's RecordSource property. If it's a query (whether a
stored query or an inline SQL statement), it probably doesn't include
the new fields, and you'll have to edit it to include them in the
selected fields. On the other hand, if that's not the problem, I've
heard of occasions where you just have to reselect the recordsource
table to make Access look at its field list again.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message