How do I build a query parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I built and i want to have the end users specifiy when
the report is selected if they want to veiw all the information, only open
information, etc. This is done oiff of the status field. I placed a ? in
the critera field and it gave me the query parameter box. However, when the
box was displayed it had the "?" instread of "Status" as the information to
enter. So basically what I would like for this to do is when the report is
open it will ask what status are they looking for. the user will enter a
status and it will only bring back that information.
 
Hi ARL

the simple way is to use the [] and this will prompt for input, but the user
will have to spell the status correctly unless you put in a like operator.

try it and let me know if that helps

Jay
 
that should say "or blank for all" or similar verbage. You put
whatever makes sense to your users.


Rick B said:
In the crieteria enter...

like [Enter Status of blank for all] & "*"





Rick B




ARL said:
I have a report that I built and i want to have the end users specifiy when
the report is selected if they want to veiw all the information, only open
information, etc. This is done oiff of the status field. I placed a ? in
the critera field and it gave me the query parameter box. However, when the
box was displayed it had the "?" instread of "Status" as the
Click to expand...
information
to
enter. So basically what I would like for this to do is when the report is
open it will ask what status are they looking for. the user will enter a
status and it will only bring back that information.
Click to expand...
Click to expand...
 
Back
Top