Using Selectable Criteria in a SQL query

[kpwhitte]

Does anyone know how to code a query so it prompts for user input, in SQL?

Code is straigt forward in ACCESS -

SELECT *
FROM GL_PeriodBudgetDetail
WHERE (((GL_PeriodBudgetDetail.FiscalYear)=[Enter Year:]))
ORDER BY GL_PeriodBudgetDetail.DateUpdated DESC;

Is there a way to make this work in SQL?

Thanks.