By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

Building query with decimal number

P: 65
I've got this query

Set rst4 = db.OpenRecordset("SELECT L,M,S FROM referenties WHERE type = '" & Form_PatChoise.ctype & "' AND geslacht = '" & Form_PatChoise.Sex & "' AND leeftijd = '" & checkage & "';")

when I remove the single quotes I get an error about a comma to much.

When I let them there I get a datatype missmatch. I can't change the field to text because I use the field to calculate some other values.

I know this could have to do with location settings but why does access allow comma's (,) in a column anyway then. Americans should follow standard (our) rules. We were writing numbers with comma's more than a thousand years ago. Now they change it and everybody has to cope with that.

Same goes for dates GRRRRRRRRRRR

Sry to all Americans but I had to get it out
Jul 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: 65
Ok I solved the problem in some way. I'm now casting everything to string to write it in the table and casting it back to what I need when I read from the table.
Jul 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.