Hello.
I have an MSSQL 2000 table that holds calendar information for a school district with seven schools. My fields are as follows: Site=which school; Key=whether public or private; Month=what month

If I wanted the recordset to be filtered by two sites AND the key AND the month... well, how can i do this?

Right now i have...
WHERE Site = 'variable1' AND Site = 'variable2' AND key = 'variable3' AND month = 'variable4'

but this isn't working as i planned. any ideas?
tmb

Edited by - vineire on 05 Sep 2003 00:27:21