|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 13th, 2006, 05:53 PM
posted to microsoft.public.access.reports
|
|||
|
|||
New tablefield to report ?
I have added a new field to one of my tables.
This new field I also want to add to my report, but when I click on "Field list" the new field is not showing in the list. How can I update the "Field List" so that I can drag the new field to my report ? www.photo.activewebsite.dk 
|
|
#2
February 13th, 2006, 06:10 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
New tablefield to report ?
The report is most likely base don a query, not a table. You must first add
the field to the query, then it will be available in the report. -- Rick B "SpookiePower" wrote in message oups.com... I have added a new field to one of my tables. This new field I also want to add to my report, but when I click on "Field list" the new field is not showing in the list. How can I update the "Field List" so that I can drag the new field to my report ? www.photo.activewebsite.dk
|
|
#3
February 13th, 2006, 06:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
New tablefield to report ?
SpookiePower,
Probably because you didn't add that new field to the query behind the report. If you're using the query design grid, drag that new field onto the grid, and it should now show up as available on the report. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "SpookiePower" wrote in message oups.com... I have added a new field to one of my tables. This new field I also want to add to my report, but when I click on "Field list" the new field is not showing in the list. How can I update the "Field List" so that I can drag the new field to my report ? www.photo.activewebsite.dk
|
|
#4
February 13th, 2006, 06:17 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
New tablefield to report ?
On 13 Feb 2006 09:53:10 -0800, SpookiePower wrote:
I have added a new field to one of my tables. This new field I also want to add to my report, but when I click on "Field list" the new field is not showing in the list. How can I update the "Field List" so that I can drag the new field to my report ? www.photo.activewebsite.dk You added the field to the table, but the table may not have been the record source for the report. The record source is most probably a query. In design view, display the report's property sheet. Click on the Data tab. If the record source is not the table, click on the line ,then click on the little button with 3 dots. when the Query grid opens, you can add the new table to the grid. Save the changes -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#5
February 13th, 2006, 06:29 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
New tablefield to report ?
Thanks all of you.
It works with your help.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
| Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
| To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
| Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
| Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Linear Mode
