P
Pam
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.
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.