Echoing Tamar: I buy mine at 3 for $7.98 at Wal-Mart. I could get Rx ones, and may do that some day, but this has worked for the past ~30 years. YEMV (Your Eyes May Vary)

>>>>
>>>> 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???