I'm back again and going insane.
In a query I have Sum([Convert]*[Quantity])
[Convert] is a weight and [Quantity] is the quantity of labels needed.
In another query this has worked perfectly, but in this current one it is already multiplying the quantity by 556.
example: It should be 2.5*1=2.5
It is giving 2.5*1=1390
2.5*2=2780
Nowhere in the formatting of Quantity do I have 556, so unsure where or why it is pulling that number.
In a query I have Sum([Convert]*[Quantity])
[Convert] is a weight and [Quantity] is the quantity of labels needed.
In another query this has worked perfectly, but in this current one it is already multiplying the quantity by 556.
example: It should be 2.5*1=2.5
It is giving 2.5*1=1390
2.5*2=2780
Nowhere in the formatting of Quantity do I have 556, so unsure where or why it is pulling that number.