date wild card issue

[wheels27]

i need to write a query that looks at month and year but can use a wild card for the date there for pulling all date within a paticulare month and year would i use the following 08/??/2001 or is it differant.

?? being my wild card or what is the wild card for a query

 

[rac2]

You could use the DatePart function like so -

(DatePart("m", [OrderDate]) = 8) and (DatePart("yyyy", [OrderDate]) = 2001)

 

[MichaelRed]

but you can't use a wild card character in an actual date type field. not even as a part of a parameter. You COULD use a calculated field and use an modified date string as the parameter criteria:

MyCaldDt: Format([the date field], "mmyy&quot

And then have the criterial be "0802"

And -of course- there are a LOT of variations on this theme!


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over