New tablefield to report ?

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

SpookiePower

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
 
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.
 
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.
 
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
Click to expand...

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
 
Back
Top