-
There are two ways you could do it.
1. The easy one is just getting every record (which you already have) and filter them when they are present in excel (but could cost extra time when there are a lot of records).
2. Building a selectif selection based on the where clausule. You'll have to check if you filled something in for every field. Depending on this your where section will differ.
Then you've got also 'or' and 'and' as you define the where's (where mydate = x and person = x . where mydate = x or person = x).
Also take a look at this site to see what kind of expressions are possible ... http://sqlcourse2.com/select2.html
Last edited by Charlize; 11-13-2007 at 03:43 AM.
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