Can not add a field after creating report.

  • Thread starter Thread starter Aarti
  • Start date Start date
A

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

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

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