modify report

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I just realize that I need remove one field from my report and take out from
report and my query.

after I remove the field in both query and report, the report always ask me
to fill the field removed.

I can simply add a dummy value in the query to work around this.

I feel that I want to a clean application.

Any idea to avoid report continue asking field removed from the report?
I use Access 2003.

Your information is great appreciated,
 
Check if I've got this right: You've deleted a field from your query and
from your report, but you still get a Parameter box asking for the field.

This happens
1. You've deleted the field from the query but it is part of a function in
the query. (ShopDays = MyDay + 3 when MyDay has been deleted)

2. you've got the field in eg the Filter or OrderBy property of your Report

(Click in the area around your report then on the Properties box of your
report check for any reference to that field there)

3. The field is mentioned in a Control in the report eg
Sum (MyDay) when MyDay has been deleted.

4. The Field is mentioned in the SortingGrouping box.

Check through these and tell us what you find.

Evi
 
Thanks for the message,
The field is in my criteria "where clause", but the show is un checked.

The report does not ask for the field if It did not there.

Thanks again,
 
I take out the fields from where clause, but the report still ask.
Should I re create a new report for this?
or any work around?
 
Keep hunting, Souris :)
When you open the Query itself, do you still get the parameter box
appearing? Or is it only when you open the report?
Evi
 
Check if I've got this right: You've deleted a field from your query and
from your report, but you still get a Parameter box asking for the field.

This happens
1. You've deleted the field from the query but it is part of a function in
the query. (ShopDays = MyDay + 3 when MyDay has been deleted)

2. you've got the field in eg the Filter or OrderBy property of your Report

(Click in the area around your report then on the Properties box of your
report check for any reference to that field there)

3. The field is mentioned in a Control in the report eg
Sum (MyDay) when MyDay has been deleted.

4. The Field is mentioned in the SortingGrouping box.

Check through these and tell us what you find.

Evi
Click to expand...

what that message means is that some where in your query or code or
something you have a [field name] where field name is not a legal
field name. It can be an handy tool if you put it in a criteria part
of a query
select * from sample where the startDate =[Start date?] when you run
the query it will ask for the start date.

In you case the fact that you deleted a field is probably what is
causing the problem try to find a query or something that is still
referencing the deleted field.
 
Thanks for the message,
The field is in my criteria "where clause", but the show is un checked.

The report does not ask for the field if It did not there.

Thanks again,
Click to expand...

if it is your where clause a then there is your problem the check
mark is whether you display it or not . Where clauses default to
hidden, If it is in your where clause it will try and use it (Hidden
or not) and all the rest of the hints come into play. Delete the field
completely and try it.
 
Back
Top