Union Query Calculated Field format

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

Guest

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
 
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.
 
Back
Top