Union Query Calculated Field format

W

wrightlife11

I have just created a union query and in that query I have created a unit
price by dividing the quantity by the total price. How can I format that
field to be Currency?

Matthew
 
D

Douglas J Steele

You could use the CCur function to convert the quotient to a Currency value,
or you could use the Format function to format it however you want.
 
Top