PC Review


Reply
Thread Tools Rate Thread

Add new table field to Report

 
 
=?Utf-8?B?VnVsY2Fu?=
Guest
Posts: n/a
 
      29th Mar 2007
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 With Quote
 
 
 
 
Dirk Goldgar
Guest
Posts: n/a
 
      29th Mar 2007
In news:388495FF-8692-474D-A203-(E-Mail Removed),
Vulcan <(E-Mail Removed)> wrote:
> 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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display Table Field names AND Field Definitions in a Report ? (ditto for query fields & criteria) Will Microsoft Access 1 29th Aug 2007 01:14 PM
How to use a report field to populate a table field =?Utf-8?B?TmljaG9sYXMgU2NhcnBpbmF0bw==?= Microsoft Access Reports 5 14th May 2007 07:37 PM
My report displays the table field names on the report?? =?Utf-8?B?bXNhbmV3YmVl?= Microsoft Access Reports 0 13th Jun 2006 03:09 PM
Formatting a report field based on a table field... Eric Microsoft Access VBA Modules 3 13th Nov 2003 11:20 PM
How do I do to buy a value of a field of a report to a field of a table? Frank Dulk Microsoft Access Form Coding 2 14th Jul 2003 12:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:52 AM.