R
Ray
Me again, more questions..
Is it possible to use If statements in SQL for the
Database Results Wizaed. I'm developing a form which has
3 search fields, let's say Book, Author and Category. The
user can either use just one field to search or 2 or all
3 fields. So you could search for all books by Graham
Greene, all books by Graham Greene with the word "Man" in
them or those 2 criteria with a Category of "Paperback"
books. Or maybe I wouldn't do it by Ifs in SQL...
Is it possible to use If statements in SQL for the
Database Results Wizaed. I'm developing a form which has
3 search fields, let's say Book, Author and Category. The
user can either use just one field to search or 2 or all
3 fields. So you could search for all books by Graham
Greene, all books by Graham Greene with the word "Man" in
them or those 2 criteria with a Category of "Paperback"
books. Or maybe I wouldn't do it by Ifs in SQL...