Deleting fields from Report

E

Emma

Hi I have a report which displays a client's information. I have removed some
fields which are no longer in the table I deleted them from the report, but
when I run the report it's asking me for the fields as a parameter ie
table.address. How can I get rid of this?
 
J

Jerry Whittle

Check the sorting and grouping options for the report. I'm betting that it's
sorting or grouping one those removed fields.

Or there's a query for the record source of the report and it's calling on
those fields. Find that query and remove the fields there also.
 
E

Emma

You were right thanks

Jerry Whittle said:
Check the sorting and grouping options for the report. I'm betting that it's
sorting or grouping one those removed fields.

Or there's a query for the record source of the report and it's calling on
those fields. Find that query and remove the fields there also.
 
D

Douglas J. Steele

Is your report based on a query rather than a table? You may still have the
deleted fields in the query.

Also, check whether any of the deleted fields were specified in the Sorting
and Grouping dialog.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top