Hello, Is there a way of varying the key fields in a where statement? I don't mean putting a variable in as the VALUE of the key. I know you can using a "?". What I want to do is allow the user to see all of a particular set of records (primary key being client) if the date is equal to the current date and allowing her to select a subset of the client records if she enters a date other then the current date (date being an idex). I know I can do this in two separate select statements -- but I just wondered if there was a better way? Thanks, Maureen
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
