New to reporting - Adding new fields to report

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Can somebody please help. I'm new to access and attempting
to design a report. I have completed the wizard and all
looks good, but I have missed a field from a table. I cant
seem to find any way to include an additional field into
the field list.

This is probably a very basic request so I apologize in
advance.

Thanks in advance.
 
I'm not quite clear on your meaning. If you click View >
Field List and the field you want is not there, it is
because it is not in the report's record source (which I
gather is a table). If the field you want is in a
different table, you can construct a query combining more
than one table, and base the report on the query. If this
is what you want and you would like some help with it,
post details of what you are trying to do.
 
Bruce,

Thank you for the quick reply. Yes, you are correct inthat
the field I require is not showing in the field list. I
can create a query to include the file and re-generate the
report, but I had spent some time re-formatting the report
and changing the headings only to find i'm missing a field
(within the same database).

What then happens if i decide to include a further field
do I then have to re-generate the report and re-change all
the report headings, which seems alot of hard work.

Perhaps i'm missing something with the reporting side of
access.

Any further assistance you can provide will be greatly
appreciated.

Regards

Geoff
 
Geoff said:
Can somebody please help. I'm new to access and attempting
to design a report. I have completed the wizard and all
looks good, but I have missed a field from a table. I cant
seem to find any way to include an additional field into
the field list.
Click to expand...


After you've gotten the report basics set up with the
wizard, open the report in design view to do all the fine
tuning. You can then add more controls (labels, text boxes,
etc) and set their properties as needed. Be sure to use the
View menu to display the Properties, Fields and Sorting and
Grouping windows.

To add a field from the report's record source, just drag
the field from the report's Fields list window to the
desired location in the report.

When you become more familiar with these operations, you'll
start using the wizards less and less (I haven't use a
report of form wizard in years).
 
Marsh,

Thanks for the advise. That does seem to work very well
and the fields are available as soon as I change the query.

I shall proceed on that basis.

Thanks again.

Geoff
 
Back
Top