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.
Also does anyone know if you can use less than on a text field?sSQL = sSQL & " WHERE DNname.[LAST YEAR]>0 AND DNname.[THIS YEAR]=>0 AND ...
i.e.
ThanksAND DNname.[CATEGORY]<'40' AND..