Help! Simple maths not working?

%3CLINGO-SUB%20id%3D%22lingo-sub-1180781%22%20slang%3D%22en-US%22%3EHelp!%20Simple%20maths%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1180781%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20-%20I'm%20really%20stuck%20and%20need%20some%20help.%20Warning%20%3D%20novice%20Access%20user%20here%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20add%20a%20calaculation%20to%20a%20query%20-%20when%20I%20try%20to%20multiple%20a%20field%20by%20a%20number%20I%20get%20a%20calculation%20that%20is%20nowhere%20near%20right%20eg.%20%5Bfield%5D%20*%2052%20-%20in%20my%20case%20I'm%20trying%20to%20calculate%20%24400%20x%2052%20(%24400%20a%20week%20as%20listed%20in%20my%20field%20by%2052%20weeks%20a%20year%20that%20I%20type%20in)%20and%20the%20answer%20I%20keep%20getting%20is%20%24104.%20Any%20idea%20what%20is%20going%20wrong%3F%20Thanks%20sooooooooooooo%20much%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1180781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184767%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Simple%20maths%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184767%22%20slang%3D%22en-US%22%3EPlease%20show%20us%20the%20ACTUAL%20SQL%20from%20the%20query.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20show%20us%20some%20of%20the%20ACTUAL%20values%20as%20stored%20in%20the%20field%20in%20the%20table.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all - I'm really stuck and need some help. Warning = novice Access user here :)

 

I'm trying to add a calaculation to a query - when I try to multiple a field by a number I get a calculation that is nowhere near right eg. [field] * 52 - in my case I'm trying to calculate $400 x 52 ($400 a week as listed in my field by 52 weeks a year that I type in) and the answer I keep getting is $104. Any idea what is going wrong? Thanks sooooooooooooo much in advance!

1 Reply
Highlighted
Please show us the ACTUAL SQL from the query.

Please show us some of the ACTUAL values as stored in the field in the table.