I need some help working with Access DB. I am basically trying to create a query in the DB itself. What I would like to be able to do is have an if...then or a select...case type statement in the SQL Select statement. I want to say select these records Where this field equals this otherwise select these records where this field equals this. Does that make sense?? I would really appreciate any help that you could give. Email or reply here. Thanks!!!<BR>- Stew