Can not add a field after creating report.

[Aarti]

Hi,

My problem is that I already selected some fields from two
tables for create a report. After that I add a new field
in a table. I want that field also in my report. Field is
not displaying in my selected field toolbar.

I will appriciate if someone can help me.
Thanks in advance !!

Aarti

 

[fredg]

Hi,

My problem is that I already selected some fields from two
tables for create a report. After that I add a new field
in a table. I want that field also in my report. Field is
not displaying in my selected field toolbar.

I will appriciate if someone can help me.
Thanks in advance !!

Aarti

Evidently you are using a query or SQL statement as report record
source.
Add the new field to the query, then it will appear in the Field List.

 

[Aarti Saxena]

Actually I created the report using wizard. Can you help
now. Please explain step by step. I am new in MS-Access
field.

Thanks so much
Aarti

 

[fredg]

Actually I created the report using wizard. Can you help
now. Please explain step by step. I am new in MS-Access
field.

Thanks so much
Aarti

Aarti,
Open the report in Design View.
Right-click on the little square on the left side of the report, where
the top and left rulers meet, and select Properties.

Click on the Data tab.
Look at the Recordsource line.
It will have the name of the query that is the Recordsource for the
report.... or it will say "Select ... etc."

Either way, click on the button with the 3 dots that appears on that
line when you click in that line.

Find the table in the upper pane that has the field you want to add to
the report.
Click on and drag that field onto the lower panel.
Save the changes.

Now, still in Design View, click on the Field list button and drag this
new field onto the report.
Save the changes.
Run the report.

 

[Aarti Saxena]

Thank you so much fred!!

-----Original Message-----


Aarti,
Open the report in Design View.
Right-click on the little square on the left side of the report, where
the top and left rulers meet, and select Properties.

Click on the Data tab.
Look at the Recordsource line.
It will have the name of the query that is the Recordsource for the
report.... or it will say "Select ... etc."

Either way, click on the button with the 3 dots that appears on that
line when you click in that line.

Find the table in the upper pane that has the field you want to add to
the report.
Click on and drag that field onto the lower panel.
Save the changes.

Now, still in Design View, click on the Field list button and drag this
new field onto the report.
Save the changes.
Run the report.


--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.