B burrina Registered User. Local time Today, 05:20 Joined May 10, 2014 Messages 972 Jun 26, 2015 #1 I don't know what syntax I need to show this as currency. The query that it looks up displays it as Currency? PHP: DocPay: Nz(DLookUp("[DocPay]","qryEmployeeHours"))
I don't know what syntax I need to show this as currency. The query that it looks up displays it as Currency? PHP: DocPay: Nz(DLookUp("[DocPay]","qryEmployeeHours"))
P plog Banishment Pending Local time Today, 05:20 Joined May 11, 2011 Messages 12,055 Jun 26, 2015 #2 Wrap it in the Format function: http://www.techonthenet.com/access/functions/string/format.php
pbaldy Wino Moderator Staff member Local time Today, 03:20 Joined Aug 30, 2003 Messages 36,157 Jun 26, 2015 #3 It could be the Nz() function is converting it to text since you didn't specify. Try DocPay: Nz(DLookUp("[DocPay]","qryEmployeeHours"), 0)
It could be the Nz() function is converting it to text since you didn't specify. Try DocPay: Nz(DLookUp("[DocPay]","qryEmployeeHours"), 0)
B burrina Registered User. Local time Today, 05:20 Joined May 10, 2014 Messages 972 Jun 26, 2015 #4 Thanks Plog and Paul Result: PHP: =CCur(DLookUp("Nz([DocPay],0)","qryEmployeeHours"))
