i need to add a field that is not in the list

  • Thread starter Thread starter cmpgeek
  • Start date Start date
C

cmpgeek

i started this report through the wizard and pulled in all
the fields i thought i was going to need at that time. i
now need to add another field to this report. it is
already present in a table that i am currently using for
this report, but the only fields that show up in the field
list are those i originally pulled into the report. how
do i get the other field onto this report without having
to restart the report over yet again?
 
While in design vew for your report, doubl-click the black box in the upper
right corner of your screen (just above the ruler on the left border of your
scree).

Your report's properties box should come up. Go to the "Data" tab and the
"Record Source" should be highlighted. Click the Elipse button (...) to the
right and your query should open in design view. Select the additional
fields you need. Cloase and save the query. close the properties box.

Your new fields should now appear in the field picker box.

Rick B

i started this report through the wizard and pulled in all
the fields i thought i was going to need at that time. i
now need to add another field to this report. it is
already present in a table that i am currently using for
this report, but the only fields that show up in the field
list are those i originally pulled into the report. how
do i get the other field onto this report without having
to restart the report over yet again?
 
That black square is in the upper LEFT of your screen - sorry!!


While in design vew for your report, doubl-click the black box in the upper
right corner of your screen (just above the ruler on the left border of your
scree).

Your report's properties box should come up. Go to the "Data" tab and the
"Record Source" should be highlighted. Click the Elipse button (...) to the
right and your query should open in design view. Select the additional
fields you need. Cloase and save the query. close the properties box.

Your new fields should now appear in the field picker box.

Rick B

i started this report through the wizard and pulled in all
the fields i thought i was going to need at that time. i
now need to add another field to this report. it is
already present in a table that i am currently using for
this report, but the only fields that show up in the field
list are those i originally pulled into the report. how
do i get the other field onto this report without having
to restart the report over yet again?
 
Back
Top