UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Nz Function Question..., Office 2007    
 
   
briangriffey
post Feb 23 2012, 04:31 PM
Post #1

UtterAccess Veteran
Posts: 312
From: Las Cruces, NM
I have used the the following in a query field...

SumAndNull: nz([SumOfPayment Amount],0)

How do I get the currency format back on the result?
Go to the top of the page
 
+
RAZMaddaz
post Feb 23 2012, 04:52 PM
Post #2

UtterAccess VIP
Posts: 6,170
From: Bethesda, MD USA
Expr1: FormatCurrency(Nz([Money],0))

Or

Expr1: CCur(Nz([Money],0))

This post has been edited by RAZMaddaz: Feb 23 2012, 04:54 PM
Go to the top of the page
 
+
briangriffey
post Feb 23 2012, 04:57 PM
Post #3

UtterAccess Veteran
Posts: 312
From: Las Cruces, NM
Cool, it worked like a million bucks. Thanks...
Go to the top of the page
 
+
RAZMaddaz
post Feb 23 2012, 04:58 PM
Post #4

UtterAccess VIP
Posts: 6,170
From: Bethesda, MD USA
Your welcome!

RAZMaddaz
(IMG:style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
RAZMaddaz
post Feb 23 2012, 05:00 PM
Post #5

UtterAccess VIP
Posts: 6,170
From: Bethesda, MD USA
QUOTE (briangriffey @ Feb 23 2012, 04:57 PM) *
Cool, it worked like a million bucks. Thanks...


No punn intended?

(IMG:style_emoticons/default/laugh.gif)
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 11:56 AM