C
ChrisC
Hi,
in my database I have a parameter query from which the result is shown in a
form. The parameter is Like "*" & [Enter name or part of name: ] & "*".
I would like to have a button on the form, giving me the report of the query
result.
Searching the internet I noticed that parameter query should best be avoided
and replaced with the Where-statement. But I have no idea how to replace my
parameter query with this.
So in fact there are two questions:
- replacement of parameter query by Where-statement
- how to get a report based on the parameter or Where.
Thanks for any help.
Chris
in my database I have a parameter query from which the result is shown in a
form. The parameter is Like "*" & [Enter name or part of name: ] & "*".
I would like to have a button on the form, giving me the report of the query
result.
Searching the internet I noticed that parameter query should best be avoided
and replaced with the Where-statement. But I have no idea how to replace my
parameter query with this.
So in fact there are two questions:
- replacement of parameter query by Where-statement
- how to get a report based on the parameter or Where.
Thanks for any help.
Chris