Trying to have a query that can set a constant in the select statement, for
example:
SELECT Author, '11/15/2005' as Updated, PublishDate
FROM Author
WHERE Author like 'A*'

Can I prompt the user for this value as an input, for example:
SELECT Author, ? as Updated, PublishDate
FROM Author
WHERE Author like 'A*'

Maybe with a prompt "Please enter Updated date".
Before resorting to VBA or Access, just want to see if it can be done in
Excel.