Hi

I have a basic query and in the field i have (Sum Of Not at All: Sum([Brief
Intervention Training Data].[Not at All])), but i do not what 0 showing if no
data has not been assigned. How do have the query to just show total and not
a 0 field on the report. I am new to all this so a simple explanation would
be appreciated

chedd

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

On Thu, 24 Jul 2008 14:07:15 GMT, "chedd via AccessMonster.com"
<u18187@uwe> wrote:

Perhaps you could use the iif function:
iif(Sum([Brief Intervention Training Data].[Not at All])=0,Null,
Sum([Brief Intervention Training Data].[Not at All]))

-Tom.
Microsoft Access MVP


>Hi
>
>I have a basic query and in the field i have (Sum Of Not at All: Sum([Brief
>Intervention Training Data].[Not at All])), but i do not what 0 showing if no
>data has not been assigned. How do have the query to just show total and not
>a 0 field on the report. I am new to all this so a simple explanation would
>be appreciated
>
>chedd

Use a formatting string.
Sum Of Not at All: Format(Sum([Brief Intervention Training Data].[Not at
All]), "#;-#;"""";")

That is:
"#;#;"""";"

Depending on your data type, you may have to change the # to something else
if you need to show decimals.
--
Dave Hargis, Microsoft Access MVP


"chedd via AccessMonster.com" wrote:

> Hi
>
> I have a basic query and in the field i have (Sum Of Not at All: Sum([Brief
> Intervention Training Data].[Not at All])), but i do not what 0 showing if no
> data has not been assigned. How do have the query to just show total and not
> a 0 field on the report. I am new to all this so a simple explanation would
> be appreciated
>
> chedd
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ccess/200807/1
>
>