Adding a category to a report

[Guest]

I created a query from a table and then a created a report from a query using
the wizard. Now I realized I forgot a specific category in my report (Company
Name). How can I add that category (Company Name) without having to redo the
report because once I created the report I changed a lot of things and I
would hate to have to redo it. Is it possible? I tried adding the category in
my query and then went into reports, tool box & found the category I wanted
to add. I tried adding it, but it doesn't let me put (Company Name) under
page header and details. Please help...Thanks

 

[John Vinson]

I created a query from a table and then a created a report from a query using
the wizard. Now I realized I forgot a specific category in my report (Company
Name). How can I add that category (Company Name) without having to redo the
report because once I created the report I changed a lot of things and I
would hate to have to redo it. Is it possible? I tried adding the category in
my query and then went into reports, tool box & found the category I wanted
to add. I tried adding it, but it doesn't let me put (Company Name) under
page header and details. Please help...Thanks

Open the report in design view, and view its Properties. Select the
Record Source property (first on the Data tab); click the ... icon by
it, and make sure that the new field is included in the query. Save
the report and the new field should now be available.

John W. Vinson[MVP]