Parameter used in queries

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Jeff_Ward
Posts: 19
Joined: Tue Oct 10, 2017 12:44 pm

Parameter used in queries

Post by Jeff_Ward » Mon Sep 24, 2007 2:08 pm

How can I use the parameter field in a query in present yet ignore if empty. For example I have a report that I want to list only people of a certain rank, yet if I leave the parameter field empty it prints all or ignores that part of the query? ______

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Parameter used in queries

Post by kfleming » Tue Sep 25, 2007 10:13 am

You can create a calculated field that is based on the parameterr field and then use that calculated field in the query rather than just using the parameterr field itself in the query if you need more flexibility.____Kathleen__R&R Support

NovagaCax
Posts: 0
Joined: Sun Feb 25, 2018 10:57 pm

==> RE: Parameter used in queries

Post by NovagaCax » Thu May 08, 2008 9:19 am

How do we use/create a paramenter where you have to do a query using "In the List"

Post Reply