Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Add new column to existing report
Thank you. I got it. Anh- Anh2000
- Post #9
- Forum: Microsoft: Access Reports
-
Add new column to existing report
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...- Anh2000
- Post #7
- Forum: Microsoft: Access Reports
-
Add new column to existing report
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...- Anh2000
- Post #5
- Forum: Microsoft: Access Reports
-
Add new column to existing report
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...- Anh2000
- Post #3
- Forum: Microsoft: Access Reports
-
Add new column to existing report
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...- Anh2000
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
