Alex Wren
05-01-2007, 01:28 PM
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
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