Query resulting in 556 (1 Viewer)

itownson1

Registered User.
Local time
Today, 11:10
Joined
Mar 20, 2019
Messages
43
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.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:10
Joined
Feb 19, 2013
Messages
16,553
don't think we can help unless we can see the actual code you are using.

edit: that is the sql code
 

itownson1

Registered User.
Local time
Today, 11:10
Joined
Mar 20, 2019
Messages
43
Ok sorry guys. I have just figured this out.
For whatever reason, if I remove the word "sum" it works in this query, but not the other. Oh well, i'm sure i'll be in touch soon!!!
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:10
Joined
Sep 21, 2011
Messages
14,046
Do you have 556 records?
 

Users who are viewing this thread

Top Bottom