entering a criteria when a query is run

[Guest]

This is a basic question, I know, but given the following query I want to
modify it so that Access prompts the user to enter a report month, i.e.,
9/1/2006, 10/1/2006, etc.: SELECT tblExpenditureDetail.*
FROM tblExpenditureDetail
WHERE (((tblExpenditureDetail.[Expense Code])="0000037008" Or
(tblExpenditureDetail.[Expense Code])="0000037009" Or
(tblExpenditureDetail.[Expense Code])="0000037010" Or
(tblExpenditureDetail.[Expense Code])="0000037011") AND
((tblExpenditureDetail.[Serial Number]) Is Null) AND
((tblExpenditureDetail.ReportMonth)=#9/1/2006#));

My brain is blanking on how to get a parameter dialogue box to pop up for
the tblExpenditureDetail.ReportMonth value.

Thanks,

Dave

 

[Guest]

Sorry, I figured this out. You can ignore. I knew it was a basic question.