Notation numbers

[Hans]

How can I get Access to make the standard fieldnotation for numbers like 2.892,92 (2 digits and thousands-interpunction) instead of 2892,92345 (all digits and no thousands-interpunction)???
Is it really necessary to change this for every field every time I make a new query again or is there a way to make this notation standard. I can only change the notation in my query's because the tables I'm using are linked via odbc. Therefore I cannot change the notation in the original tables.

 

[hansford.cornett]

-----Original Message-----
How can I get Access to make the standard fieldnotation

for numbers like 2.892,92 (2 digits and thousands-
interpunction) instead of 2892,92345 (all digits and no
thousands-interpunction)???

Is it really necessary to change this for every field

every time I make a new query again or is there a way to
make this notation standard. I can only change the
notation in my query's because the tables I'm using are
linked via odbc. Therefore I cannot change the notation in
the original tables.

.
I myself would not know of a reason to display the

numbers as you describe but then my math was only a 3.4 or
so in school. You may however establish a query and run
this querry to display the special format you
need.....don't have a clue what it will do if you actually
do math on it though.

1. establish a query with FIELD_1 in it this contains the
numbers. Now Create Field_2 (Properly formatted Numbers)
IIf (Len[Field_1])= 8,Field_2= (Mid[Field_1],2,2)&"."&Mid
[Field1,4,3))