Query Criteria

[Robert Sykes]

I have a query (qry_cancelled) that pulls records from a table.I have set it
to prompts for a date every time the query is run. Each record has a date
stored in long date format, how would I set the criteria in the query so I
only have to put in the month and year and have it return all records for
that month year.

I hope this makes sense, thanks in advance.
--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.

 

[Gerald Stanley]

Try a WHERE clause along the lines of

WHERE Format(dateCol, "mm/yyyy") = [Please Enter Required Month as MM/YYYY]

Hope This Helps
Gerald Stanley MCSD

 

[martin]

This is discussed often here. You need to format your input before you send
it to your query. It cannot be done thru a query prompt. A query prompt has
no ability to check what the user has entered or reformat it to what the
query needs. This site does a great job explaining what you need.

http://www.fontstuff.com/access/acctut01.htm

HTH
Martin