Issues with Multiplication Expression

ttuguy

Registered User.
Local time
Today, 15:40
Joined
Mar 13, 2014
Messages
10
Hello All,

Hoping someone can help with a problem I cannot figure out. I have a table with inventory items, a separate table with storage charges per day (ex .03, .04, .05 per day/per item)

I have created some queries where I take the items & # of days they have been in storage and when I try and create an expression for storage charges based upon QTY & # of days I am getting results like it is multiplying whole numbers and not very small increments like .03

I have checked the math, and its not multiplying by 3 instead of .03... I cant quite figure out how it is coming up with the numbers.

Again, the pricing is coming from a lookup wizard to another table. It seems like it should be a very straight forward expression but for the life of me I cannot get it to work. Does the figures being from a lookup have any issues?

Cheers!
 
If there's an ID field, it's likely using the ID field. Hard to see without seeing the SQL.
 
That makes sense, how could I check and make sure it is multiplying by the value and not the ID?
 
It would have helped to see the SQL, but both tables should be included and your calculation should specify the amount field.
 
Paul,

Thanks for your reply, what is the easier way to show you the SQL? Do you want to see it for each table? Also, for the calculation how do I specify the amount field?

Chris
 
Also, I am wanting the field to show 3 decimal places... No matter how much I play in design view and change the field type, or decimal # it always displays as .03 .04 etc instead of .033 or .041
 
By SQL I mean the SQL of your query. If you have the query open in design view, click on the down arrow under the View icon and change to SQL view.
 

Users who are viewing this thread

Back
Top Bottom