Hi, I'm trying to set up a search page that will compare a date and return values either on, after or before the date requested.

I tried something like :

Select *
From Table1
where (varButton='on' and pubDate = #varpubDate#) or (varButton='after' and pubDate > #varpubDate#) or (varButton = 'before' and pubDate < #varpubDate#)

but that just returns everything. Any thoughts? PLEASE PLEASE PLEASE help!

W