|
-
Oct 5th, 2009, 12:47 PM
#1
Thread Starter
Lively Member
Ignore Null parameters in a single query
I'm programming a form where people select information to limit information they want to see. There are 10 fields, and they can choose between 0 and 10. When they click the command button, the code lifts the values out of each of the 10 comboboxes and filters it in a sql query. Is there a way to get the Select statement to disregard operations on columns assigned null parameters? Could I assign * to the null fields and have it read out like an asterisk in SQL?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|