>>>>
>>>> It appears that you have your WHERE clause twice at the end of the query....that's probably what's causing the syntax error.
>>>
>>>I used Where clause only once.
>>
>>Wash your glasses and look again. :-)
>
>Hopefully he'll get it :)
>
>Today I broke another pair of reading glasses. On average I go through 2-3 a year and I've been wearing them for 8 years now. That means I've spent roughly $450 or so on reading glasses in my life. Do you realize how much Guinness I could buy with that???

If you don't have to have prescription reading glasses, check out the dollar store. Might take a couple of tries, but until I started needing them above 3.0, I was able to get lots of pairs there.

Tamar