Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need help in multiple IF Then Else stmts that show in the query

Status
Not open for further replies.

yehong

Programmer
Sep 22, 2003
291
US
I have 7 parameters and based upon those I want to select the data. I am using 'And'condition but no luck.
thanks- CR8.5
 
Here's my FAQ on optimizing SQL pass through using the record selection formula which demonstrates best practices for creating th record selection forumla using multiple parameters:

faq767-3825

Had you stated specific questions, someone would have addressed those.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top