Append query based on a wildcard date

[martin DH]

I'm trying to create an append query (for the purpose of archiving data) that has one parameter value asked:

"Archive data for what date?"

I want the user to enter the date of choice in the parameter value dialog box so that all data with the entered date is archived (appended).

INSERT INTO STARTS_ARCHIVE
SELECT STARTS.*
FROM STARTS
WHERE ((STARTS.ScheduledRunDate) [Archive data for what date?]);

I've tried several different options and could use some simple help. I'm using MS Access 2003. Thank you!

[Rabbit]

Query > Parameters
That'll let you define your parameters and their data type.

[martin DH]

Query > Parameters
That'll let you define your parameters and their data type.

That option is grayed-out....

[Rabbit]

You're in SQL View, go to query design view.

[martin DH]

You're in SQL View, go to query design view.

Oops. Thanks. Now, in "parameter" what do I type for what I am trying to accomplish: the user enters a date and the query appends all records with that date? I know the "data type" is date/time.

[martin DH]

Oops. Thanks. Now, in "parameter" what do I type for what I am trying to accomplish: the user enters a date and the query appends all records with that date? I know the "data type" is date/time.

Sorry! I just figured it out. I just type in "parameter" whatever I want to appear in the popup dialog box and it takes care of the rest, correct?

[Rabbit]

You give the parameter a name, which is what the user will see. Let's say you named it [User Defined Date]

Then in the query, it'll be:

PARAMETERS [User Defined Date] DateTime;
SELECT *
FROM SomeTable
WHERE Format(DateField, "m/d/yyyy") = Format([User Defined Date], "m/d/yyyy");