J Joe M Oct 30, 2003 #1 How do I format a Query as Currency and not as double.eg Tax: [Sales] * 1.1 this would default to double ....
How do I format a Query as Currency and not as double.eg Tax: [Sales] * 1.1 this would default to double ....
D Douglas J. Steele Oct 30, 2003 #2 If Sales is already currency, try: Tax: [Sales] * CCur(1.1) If it's not, try: Tax: CCur([Sales]) * CCur(1.1)
If Sales is already currency, try: Tax: [Sales] * CCur(1.1) If it's not, try: Tax: CCur([Sales]) * CCur(1.1)
