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

Welcome Guest ( Log In | Register )

> Totals Query, Office 2010    
 
   
slickvick
post Apr 11 2012, 11:55 AM
Post #1

UtterAccess Addict
Posts: 236
Hello,

TotalCalls: Nz([CountOfApproaches],"0")

"Expression"


I get a nill result even if countofapproches has a number.

Why?


Vick
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 2)
Peter46
post Apr 11 2012, 12:02 PM
Post #2

UtterAccess VIP
Posts: 7,394
From: Oadby Leics, UK
TotalCalls: Nz([CountOfApproaches],"0")
your expression implies that CountOfApproaches is a text field.
If it is text then you will have to post more details of your query (SQL View) and a bit of explanation.

If it is number then remove the " ".
Go to the top of the page
 
+
slickvick
post Apr 11 2012, 01:48 PM
Post #3

UtterAccess Addict
Posts: 236
thank you peter 46,

It is a number and it worked perfectly!!! (IMG:style_emoticons/default/smile.gif)



Vick

This post has been edited by slickvick: Apr 11 2012, 02:23 PM
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: Switch to: Standard · 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 - 02:00 AM