Select Query fails

[kirkm]

I'm sure this normallly works, but is now failing and I can't see why.

My Select Query is

SELECT [OZburn by Year].Title
FROM [OZburn by Year]
WHERE ((([OZburn by Year].Title)="Back In Your Arms"));

It finds nothing because the source table string is

"Back in Your Arms" with a lower case "i".

How do I ignore whether anything is Upper or Lower case?

Thanks - Kirk

 

[Jeff Boyce]

If I recall correctly, Access already ignores the case.

Are you saying that the query does work if you use the upper case "I"?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/