Rounding problem

[CEH]

Have a little problem that I can't seem to correct. In a subform that calculates "items" ordered by multiplying by "Quantity" my "Total" is not rounding correctly... I have went thru the DB and checked all number fields to make sure they were set to Single or double.... But the total draws from a calculation in a query... How can I set this to "Double" and make the calculation return the correct result??

 

[David Eagar]

Right click on the calculated field in the query and in properties, set correct format

 

[CEH]

You cannot set it as Double or single from there. Only the format. If Standard, fixed... currency ..... doesn't matter, makes no change.

 

[Cosmos75]

How about using the Cdbl() function?

 

[CEH]

Thanks Cosmos, that led me to do this...... seems to work as field in query
Price: Format(CDbl([ItemPrice]+[UnitCost]*[ItemMarkup]),"Fixed")

 

[Cosmos75]

CEH,

Glad that helped!

 

[ajentp]

Thanks Cosmos, that led me to do this...... seems to work as field in query
Price: Format(CDbl([ItemPrice]+[UnitCost]*[ItemMarkup]),"Fixed")

I have similar problem . Is this correct code Like Format(CDbl.....), "Fixed). It is not working for me.

Any help please

 

[CEH]

Well if that is the code you left out the last parenthesis after "fixed" Check your syntax, or post your exact code.

 

[ajentp]

Hi CEH,

Thank you for the tip. It is working now. My code is

=" 1 " & Format(CDbl([Price1]),"Fixed") & " 2 " & Format(CDbl([Price2]),"Fixed")

 

[ajentp]

Hi CEH,

Thank you. It is working now. My code is:

=" 1 " & Format(CDbl([Price1]),"Fixed") & " 2 " & Format(CDbl([Price2]),"Fixed")
It will give output like:

1 69.10 2 65.34

 

[CEH]

I said parenthesis and meant quote...well, you got the idea! Glad it's working for you.