Rounding issue

[Ben_Entrew]

Dear all,

I got a weired issue here. There are two reference ids in the original table:

Ref No. Price Customer

434121 101,471018 A

434121 101,471018 B

Now after some calculating (withount any known roundings from my side)
ıt shows me this ın another table:

Ref No. Price Customer

434121 101,471018 A

434121 101,470000 B

Does anyone has a clue why this happens? Where can I look at?

The total numbers differ to EXCEL here and I'm getting desparate.

Thanks in advance.

Regards,
Ben

 

[JHB]

Do you calculate them as currency?
What result do you get in Excel and what result do you get in MS-Access?
Show you calculation + some values.

 

[Ben_Entrew]

Hi all,

I found out that there was a data inconsistency, created by a colleague here.

So I do not have to change anything in the code.

Thanks.

Regards,
Ben