help with filtering

[dreamdelerium]

hi everyone. i have a question about filtering a table. i have a table with 50 columns and 900 rows. for each row, i want to goto column 5. if column 5 is equal to "1" or "2" i then want to goto column 10. if column 10 is equal to "6" or "7" i want to filter the row from the table by exluding it. how can this be done?

thanks in advance

[PianoMan64]

hi everyone. i have a question about filtering a table. i have a table with 50 columns and 900 rows. for each row, i want to goto column 5. if column 5 is equal to "1" or "2" i then want to goto column 10. if column 10 is equal to "6" or "7" i want to filter the row from the table by exluding it. how can this be done?

thanks in advance

[CODE=VB]
SELECT * FROM {TABLENAME} WHERE (Column5 Like 1 or Column5 Like2) AND (Column10 Not Like 6 or Column10 Not Like 7
[/Code]

That is what my understanding of your filter is. You need to replace the {TABLENAME} with the table name that you're searching on since you didn't include that in your question. I'm also assuming that Column Names are Named as discribed. If you need futher help, please email me at this site.

Hope that helps,

Joe P.