DatePart referring to field on a form

[weezles]

Hi

I want to return records where the year of a date in each record matches a year the user enters on a form. I have the following where clause:

WHERE (DatePart("yyyy",[tblClient.DateA])=[forms]![frmRptMenu].[form]![txtYear])

I get no records returned although this works if i just enter the year within the query.

Any suggestions?

Thanks

Lou

 

[SkipVought]

Hi,

try converting the text date on the form to integer via CInt function

WHERE (DatePart("yyyy",[tblClient.DateA])=CInt([forms]![frmRptMenu].[form]![txtYear]))

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[PHV]

And this ?
WHERE Year([tblClient.DateA])=[Forms]![frmRptMenu]![txtYear]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[weezles]

Hi

I tried both of your suggestions, unfortunately neither worked. However both work if i replace
[Forms]![frmRptMenu]![txtYear] with an actual year.
I have checked the form and field names are spelt correctly so I dont know what else to try.

thanks

Lou