Beginner-how to add to reports?

[gloria]

Absolute beginner (1 week). I have created a Report based on 2 Tables and Forms. I selected fields from the field list to make up the Report.
When I add a new field to the Table, it automatically appears in the Forms field list which I can update, yet it does not appear in the Report field list even when added to the Form.
As this must be a common action,ie adding data then updating Reports, I imagine there is a very simple way of doing it, a secret closely guarded by all editors of access manuals!
I am using Access 97. I tried using an AppendQuery containing the new field only but there is no option to send it to a Report.
Please help! Thanks.

 

[ColinEssex]

Hi Gloria

Not 100% sure what you mean but its best to have reports based on queries rather than the actual tables. That way you can enter or be prompted for criteria i.e. date ranges etc to get the right data on the report.

Just create a select query and the fields you need, then add those fields to the report. (you'll need to have the query name as the control source of course) Use the report wizard to do the spadework for you then amend the report as needed for finishing touches.

Don't forget if you want to be prompted for a date range (or whatever) put [Enter Start Date] in the query criteria line under the StartDate field. (sorry if you already knew this bit)

Col