*/*/&[What year do you want?]

[Gordon]

I'm trying to set up a parameter for a query which would allow the end user to type in a year, and have it show all occurances for the year.

I've tried the following syntax, which does not work.....

Like "*/*/&[what is year?]

Any suggestions for the correct syntax on this?

Thanks!


Gordon

 

[Gordon]

DATEYEAR: DatePart("yyyy",[Date])

Thanks - I ended up using the syntax DATEYEAR: DatePart("yyyy",[Date]) and putting the parameter [What Year do you want?] in the criteria. This worked.

Gordon