Connecting Tech Pros Worldwide Forums | Help | Site Map

Add a field to a report after adding field to table?

Randy
Guest
 
Posts: n/a
#1: Nov 13 '05
I built and employment report from the employment table. I then had to
add a field to the table. I now need to add that field to the report.
I can't seem to be able to do that by clicking on table icon and adding
the field as it is not listed.

How am I able to add the new field to the report?


Allen Browne
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Add a field to a report after adding field to table?


Open the report in Design view.
Open the Field List (View menu.)

If the report is bound to the table, you will see the new field in the Field
List, and you will be able to drag it onto your report.

If the report is bound to a query, you may have to open the query in design
view and add the field there, before it shows up in the Field List of the
report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy" <ranmcc@msn.com> wrote in message
news:1115218607.780955.251590@z14g2000cwz.googlegr oups.com...[color=blue]
>I built and employment report from the employment table. I then had to
> add a field to the table. I now need to add that field to the report.
> I can't seem to be able to do that by clicking on table icon and adding
> the field as it is not listed.
>
> How am I able to add the new field to the report?[/color]


Closed Thread