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.

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.

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.