Add new column to existing report

[Anh2000]

Hi,
I recently add a new column(N) to a table (A). So I add that column(N) to the existing query (B). However, the report(C)that's built on that query (B) does not show that new column (N). How can I add that column (N) in the report (C)? I manually add a new field in that report (C) and use SQL in property/control source to select the column (N), but it does not work.
Would you please help? Thank you so much.
Anh

 

[dhookom]

A report has a record source which must include your field. Once the record source has the field, you can then bind a text box in your report to the field.

Duane
Hook'D on Access
MS Access MVP

 

[Anh2000]

My issue is that is a newly created column in a table. How can I add that column in a report? That new field does not show on the record source. If it shows, I have no issue. I already manually created an Unbound field and used SQL to select that field. But I had error #Name on th ereport output for that field. Is there a way to work around? I don't want to recreate a total brand new report. I want to modify the existing report and add the new column in there. Is it impossible to do?
Thanks,
Anh

 

[dhookom]

What is the Record Source of your report? Apparently it is not the table. It is probably a query or SQL statement that doesn't include the new field. Edit it to include the new field.

Duane
Hook'D on Access
MS Access MVP

 

[Anh2000]

Hi duane:

I did add it in the original query. However, in the report design mode, the Field has not shown that new column. What should I do? I manually create an unbound box and use SQL (in control source in properties of that box) to select that column, but I receive an error. Thank you for helping.
Ann

 

[dhookom]

Answer my question "What is the Record Source of your report?"

You can't use SQL in a control source.

How about telling us about your record source and tables and field names.

Duane
Hook'D on Access
MS Access MVP

 

[Anh2000]

I created 2 tables:
1/ Tbl_Project: PJ_ID, PJ_Name, Team_Leader, Teammember1, Teammember2, Teammember3, Teammember4, Teammeber5 (more attributes but I want to make it short here)
2/ Tbl_PJ_Tracking:T_ID,Date, Complete_Count, Issue_Count, PJ_ID (foreign key from table 1)

A/ I create a query to link 2 tables above and a parameter window to enter project name.

B/ I create a report based on this query.(with summary for each count columns)

C/ Later I add another column in table 2 as Pending_Count

I aslo add that column in the query.

I open the report in design view and add that new column in the report. The Field does not show the new column.

How can I modify that report an dadd the new column there?

Thanks,
Anh

 

[dhookom]

You still haven't answered my question. Can you find the Record Source property of your report? What is it? If it is a query name, what is the SQL view of the query?

BTW: Your table structure is highly un-normalized. It might work for you but I would not have fields like "Teammember1, Teammember2, Teammember3, Teammember4, Teammeber5".

Duane
Hook'D on Access
MS Access MVP

 

[Anh2000]

Thank you. I got it.
Anh