K Kassy Registered User. Local time Today, 13:24 Joined Jan 25, 2006 Messages 66 Apr 20, 2006 #1 Can anyone amend this statement because presently I am getting an eror 'The expression you entered has an invlid string 'WHERE Month([PaymentDate])>07 And <11'
Can anyone amend this statement because presently I am getting an eror 'The expression you entered has an invlid string 'WHERE Month([PaymentDate])>07 And <11'
pbaldy Wino Moderator Staff member Local time Today, 05:24 Joined Aug 30, 2003 Messages 36,157 Apr 20, 2006 #2 This part: ...And <11 and what is less than 11? I know what you want, but Access won't make the assumption. You have to repeat the Month(...) bit.
This part: ...And <11 and what is less than 11? I know what you want, but Access won't make the assumption. You have to repeat the Month(...) bit.
K Kassy Registered User. Local time Today, 13:24 Joined Jan 25, 2006 Messages 66 Apr 21, 2006 #3 Sorry - your right obvious really now you have pointed it out! Thanks
