Add a field to an already created report

N

Nicole

I am a complete idiot to MS Access. I used the Inventory
Wizard to try and set up a new database. My report is
half way there, but it doesn't seem like the report screen
is connecting to the table and form screen information.
How do I get these to show up on my reports?
 
P

Patrick

HI Nicole!!

If you're having problem with adding a new field to a
report make sure that in the textbox properties of this
new field that you've entered something in the Control
Source of this object. It needs to have a reference to the
new field otherwise it doesn't know where the information
is comming from.

So if you have something written in the control source,
And its still not working, his your report perhaps
connected to a query, if so, you need to add that new
field inside the SELECT Clause of that query. OtherWise,
it doesn't know what your refering to.

If that's not working, his this report connected to a
table where the new field doesn't exist. Then you must
create-it in design mode( for the table in question) and
insert ,in view mode, a few lines of data for testing
purpuses.

The bottom line is, when creating the report always make
sure that the table will always have all the desired fields
(columns) that you require before starting the Report
Wizard.

This should give you a few things to check for.
Hope this helps,

Patrick
 
J

Jan en Riet Geusebroek

Nicole said:
I am a complete idiot to MS Access. I used the Inventory
Wizard to try and set up a new database. My report is
half way there, but it doesn't seem like the report screen
is connecting to the table and form screen information.
How do I get these to show up on my reports?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top