number of query values and destination fields are not the same

[markvl]

I've got a simple form showing the fields of a query that lists the contents of a table 1:1. Access handles everything.
One of the fields is a number. When I want to insert a -new- record and use a number like 0,9 or 22,6 I get the error message mentioned in the subject. 22,0 goes fine. (My decimal point is a comma).
Once a record exists it is no problem updating the number to one with decimals, like 22,6.

Why would the insert treat the comma like a separator or something like that? And what can I do about it?

 

[TheAceMan1]

How are ya markvl . . . . .

[blue]One of the fields is a number.[/blue]

By this I take it you mean this Field is a [blue]Numeric Data Type[/blue]. Is this correct?

If so . . . . than perhaps you can tell me:

What number is [blue]0,9[/blue]?
What number is [blue] 22,6[/blue]?

If you see my point, [purple]this field needs to be Text data Type![/purple]

See Ya! . . . . . .

 

[PHV]

When I want to insert a -new- record
How do you do that ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244