CCur

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following in a Query,
Total: CCur([Quantity]*[Spreading]+[Quantity]*[Cartage])*1.125
It gives me the correct maths to 3 decimals, but Will not show in a currency
format.
What am I missing.
Any suggestions appreciated and thanks in advance.
 
You're probably loosing the currency data typing because your "* 1.125" is
outside of the CCur function.

Try: CCur(([Quantity] * [Spreading] + [Quantity] * [Cartage]) * 1.125)

If this doesn't do the trick, right click the column, select properties, in
the Format property dropdown, select Currency.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
M.L. Sco Scofield said:
You're probably loosing the currency data typing because your "* 1.125" is
outside of the CCur function.
Click to expand...

Yes, and is easily demonstrated e.g.

SELECT TypeName(CCur(1) * 1.25)

returns 'Decimal' against a Jet 4 mdb (don't tell Allen Browne: he
*hates* Decimal <g>).

Jamie.

--
 
Back
Top