Adding fields to report

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I do not use reports much and when I do, I always use the wizard and then
move the informaiton around to have it look the way I need it to.

I have a report, but now I need to add more information (fields) to the
report from a table that I did not add during the wizard. How do I add
table/fields to use in the report.?

Rebecca S.
 
On the report design toolbar you can open the fieldlist
(looks like a printed page icon) and than drag and drop
the desired fields to your report, or you can click on the
textbox icon on the toolbox toolbar (looks like <abl> and
than click on the report in design view and specify the
data you wish to use.
Hope this helps.
Fons
 
The fields are not in the field list because I didn't add them in the wizard
to begin with.

I am needing to add about 30 more fields and was hoping there would be a
quicker way than to do a textbox for each one.

Also the field I need is a check box field, ..

Rebecca S.
 
Okay, so what you realy need to do is add them to the
query on which the report is based.
Open the report in design view,
Open the properties window from the view menu,
click on the data tab
place the cursor in the record source field,
a box will show to the right of the field, click on it,
this will open the query design window with the table with
all available data fields.
add the data fields you wish to add.
now close the query design window, and save.
in the report design window open the field list and add
the desired fields.
Proceed with formatting etc:
Hope this helps.
Fons
 
Back
Top