parameter questions

[Stephanie]

I am VERY new to access and have inherited a report from a
former co-worker. I export information from another
program to be used in access tables. I then go into the
query to adjust some calculations. This time when I opened
the queries, it asked me for parameters. I have no idea
how these got there or what to do with them. I found the
expression in the design view that I believe was
responsible for the parameter prompts and deleted them. I
no longer have the parameter prompts in the queries,
however when I try to open the report, it is there again.
How do I get rid of this. If you could be very specific,
it would be appreciated since I have no idea what I am
doing!!!

Thanks

 

[Edward Bender]

I am VERY new to access and have inherited a report from a former
co-worker. I export information from another program to be used in
access tables. I then go into the query to adjust some calculations.
This time when I opened the queries, it asked me for parameters. I have
no idea how these got there or what to do with them. I found the
expression in the design view that I believe was responsible for the
parameter prompts and deleted them. I no longer have the parameter
prompts in the queries, however when I try to open the report, it is
there again. How do I get rid of this. If you could be very specific,
it would be appreciated since I have no idea what I am doing!!!

Thanks

When this has happened to me, it is usually due to a mispelled field
name which might be an actual spelling problem or a misplaced comma in
the SQL statement behind the design view. I have fixed this by going
into SQL view in the queries section and carefully examining each and
every field name and associated punctuation.

 

[Guest]

Open report in design view.
Click on the little black square in upper left of screen of the report
design form.
Click on Data Tab: Record Source
Click on to open Record Source
The query that the report in based on will open up.
Double check that the parameter has been removed.
Joan