Reply to thread

Message: [QUOTE="MGFoster, post: 2334150"] -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 If your Access is set up to use Malaysian currency symbols you can use the Format() function: Format(Fees]*IIf(DCount("*","tblRobinson","FatherName=""" & [FatherName] & """ AND StudentName <""" & [studentName] & """")=0,1,0.95), "Currency") AS Discounted The "Currency" indicator will add the "RM" to the discount amount. If you are using a form to show the query's output set the Discounted control's Format property to Currency, to get the same results. -- MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) ** Respond only to this newsgroup. I DO NOT respond to emails ** -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBSU8uooechKqOuFEgEQJnXQCg+W53gHzFfjhfqD+F53TDB1yPwuEAmwff vL/I8ubYj+8b6H1ntEHV7lpu =UVBr -----END PGP SIGNATURE----- [/QUOTE]