Hello,

Having problems with two things.

I have a nice little bit of Excel VBA that queries a table within an Access db. Problem being is that the client has formatted the field as currency and the following code does not work.

sSQL = sSQL & " WHERE DNname.[LAST YEAR]>0 AND DNname.[THIS YEAR]=>0 AND ...
Also does anyone know if you can use less than on a text field?

i.e.
AND DNname.[CATEGORY]<'40' AND..
Thanks