Syntax for a Parameter Query with extra bits required?

[Legacy 154275]

Hi all

I have to create a Para query to list all pets born in a particular year, thats easy I think [Enter the Year of Birth] in criteria, so thats all good it askes me for a year, and wham NOTHING returned

What am I doing wrong please?

 

[tweedle]

you're comparing as such: [Enter the Year of Birth] = Year([DOB])
Yes?

 

[Legacy 154275]

you're comparing as such: [Enter the Year of Birth] = Year([DOB])
Yes?

Hi mate and tx but no go

I have to use a Parameter search so I need a question dialog box to appear, and it has to search on the Year in the PetDOB Table which has 01/01/1999 etc in it.

The above gets me the question dialog box, but zip in results.

Is that understandable?

 

[tweedle]

Yes, however I can't force the same result on Access 2007.
You might try wrapping them both in CInt
i.e. CInt( [Enter the Year of Birth] ) = CInt( [DOBField] )

 

[Legacy 154275]

Hi again mate and thank you!!

Just reveresed your first one Year([PetDOB])=[Enter Year] Works a treat as well

I do not know why this one works and your first one did not?

I may well be back with more LOL