If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding Additional Fields to a Report Created Using Wizard -Access
I have created a report using the wizard, based on a query in Access 2007.
However, I want to add an additional field to the query and the report. I added the new field to the query and it runs just fine. However, in the report, in design view, I have tried adding a text box to show the results of that field and it doesn't work. It's just another field from the same table I have been using. In design view, when I go to the Control Source for the text box, the field I want to add does not show up. I can't figure out what I'm doing wrong. Once I change the query, is there something I must do to update the information so that it shows up on the report (in the Control Source for that new text box)? The funny thing is, if I create a NEW report based on that same query, and add that new field, it works fine. |
#2
|
|||
|
|||
Adding Additional Fields to a Report Created Using Wizard -Access
Hi Pam
With the report in design view, try selecting the report properties, in the Record source for the report, press the three dots ... next the Record source. This will open the query on which the report is actually based on. Check to see if the additional field is in the design view of this query???? If its not, add it from the table in the top of the query. I hope this helps Regards Mike B -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "Pam" wrote: I have created a report using the wizard, based on a query in Access 2007. However, I want to add an additional field to the query and the report. I added the new field to the query and it runs just fine. However, in the report, in design view, I have tried adding a text box to show the results of that field and it doesn't work. It's just another field from the same table I have been using. In design view, when I go to the Control Source for the text box, the field I want to add does not show up. I can't figure out what I'm doing wrong. Once I change the query, is there something I must do to update the information so that it shows up on the report (in the Control Source for that new text box)? The funny thing is, if I create a NEW report based on that same query, and add that new field, it works fine. |
#3
|
|||
|
|||
Adding Additional Fields to a Report Created Using Wizard -Acc
Mike B ...
Thank you so much! That was exactly what I needed to do ... add that field to the query. Pam "MikeJohnB" wrote: Hi Pam With the report in design view, try selecting the report properties, in the Record source for the report, press the three dots ... next the Record source. This will open the query on which the report is actually based on. Check to see if the additional field is in the design view of this query???? If its not, add it from the table in the top of the query. I hope this helps Regards Mike B -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "Pam" wrote: I have created a report using the wizard, based on a query in Access 2007. However, I want to add an additional field to the query and the report. I added the new field to the query and it runs just fine. However, in the report, in design view, I have tried adding a text box to show the results of that field and it doesn't work. It's just another field from the same table I have been using. In design view, when I go to the Control Source for the text box, the field I want to add does not show up. I can't figure out what I'm doing wrong. Once I change the query, is there something I must do to update the information so that it shows up on the report (in the Control Source for that new text box)? The funny thing is, if I create a NEW report based on that same query, and add that new field, it works fine. |
Thread Tools | |
Display Modes | |
|
|