How do you go about if you want to be able to acquire user input in a direct union query in Access? I have a code that follows:

BEGIN
SET NOCOUNT ON
DECLARE @startdate varchar(20)

SELECT @startdate = '20030401 00:00:00'

If I want to be able to change the startdate according to the wishes of a user, how do I do that?

/Pfeni