Problem in the field of currency

[azhar2006]

Hello Guys
I suffer from currency figures
I have two fields for his work in the field and a third form for the collection of these fields
What is happening is
When I enter, for example, $ 100 in a field number one
And 603 dollars in the field No. 2


Be the result of field No. 3 is
603,100
In other words be $ 100 a Cent
Where it should be the amount is 703
What is the solution

[orange]

It sounds like you are adding text strings. Make sure you are dealing with numeric data type.

Show us your field definitions.

[azhar2006]

Yes I'm sure it's digital
But there is a point at $ 100
There is a comma in the 610

[orange]

Can you show us the fields and their datatype? Or post a copy of the database with private/confidential stuff removed.

What is the expression that does the addition?

[azhar2006]

ok

SELECT Table1.ID, Table1.COM, Table1.DAT, Table1.Paid, Table1.nammad, Table1.Quantity, Table1.purity, Table1.Ounce, Table1.wages, ([Ounce]/31.1) AS IOunce, [IOunce]*[purity]+[wages] AS Igram, [Quantity]*[Igram] AS Expr1, [wages]*[Quantity] AS Expr3, [MB]-[Expr1] AS Expr2, [Quantity]*[purity] AS Expr5, [IOunce]*[Expr5] AS Expr4
FROM tblCOM INNER JOIN Table1 ON tblCOM.IDCOM = Table1.COM;

[orange]

Please show the definitions/datatypes for
Ounce
Purity
Wages
Quantity

[azhar2006]

OK
Thank you for your help
This is the structure of the tables
That's where the table that is based on his fields that I mentioned is
tblFOreign_Companies
That's where his name was mentioned table (Table1)