Update table problem

[mmiklauz]

Hi, Access experts! Can someone explain me what is happening (btw sorry for my bed English). I have trouble with updating table. So, in one table I have column (Data Type=Number, Data Size=Double) and in another table I have the same data type and Dana Size column. The problem is when I update the second table with column data from first table I get different number format. I struggling with this problem for two days and I can't understand what is happening.



Thanks in advance,

[JoeM]

That's just the Format property (you can see it is below "Field Size" and above "Decimal Places" in your screen print. You have not selected anything for this property.
Click on the format property and choose the option you want (one that includes commas).

[mmiklauz]

That's just the Format property (you can see it is below "Field Size" and above "Decimal Places" in your screen print. You have not selected anything for this property.
Click on the format property and choose the option you want (one that includes commas).

I did. But still the same thing

[JoeM]

When you hit the drop-down box, it shows the different options, and what they look like.
General Number does NOT show commas. Choose one that does, like Standard.

[mmiklauz]

When you hit the drop-down box, it shows the different options, and what they look like.
General Number does NOT show commas. Choose one that does, like Standard.

Again, I get different format. I can't understand...

[JoeM]

Please explain how you are updating one table from the other.
Are you using an Update Query? If so, please post the SQL code for that query.
It looks like you are dividing the value by 1000.

[mmiklauz]

Please explain how you are updating one table from the other.
Are you using an Update Query? If so, please post the SQL code for that query.
It looks like you are dividing the value by 1000.

Yes I use Update Query,
there is SQL code:

UPDATE DISTINCTROW TkontoSum INNER JOIN Tmmdogu ON (TkontoSum.nivo = Tmmdogu.nivo) AND (TkontoSum.konto = Tmmdogu.konto) SET Tmmdogu.[dec] = [Tkontosum]![SumOfiznos], TkontoSum.nivo = [TkontoSum]![nivo], Tmmdogu.konto = [TkontoSum]![konto]
WHERE (((TkontoSum.nivo)=[TkontoSum]![nivo]) AND ((Tmmdogu.konto)=[TkontoSum]![konto]));

[JoeM]

I am not sure what is going on. It may have something to do with your Regional Settings (where it may be trying to use commas to denote decimals instead of periods).

[mmiklauz]

I am not sure what is going on. It may have something to do with your Regional Settings (where it may be trying to use commas to denote decimals instead of periods).

Ok, thank you for your help..

[JoeM]

You are welcome.

That is where things get tough to replicate, when people are using different versions of Access with different regional settings.
You may want to play around with those, and see if you can get it working the way you like.
I would just recommend setting both tables to use the same Data Type and Formats, so you at least eliminate any confusion that may cause.