do not show zero values in query

[Guest]

OOPS... Expression shows me JAN 2004 Sales
even when there are none.. it shows $0.00...
I don't want to view $0.00 just when there is a sale

04 JAN Sales: Sum(Abs(Year([PostMonth])=2004 And
Month([PostMonth])=1)*[CommVolume])

 

[Duane Hookom]

You can use the format property of a text box on a form or report to display
zero values as Null or blank.

 

[Guest]

I don't want the customer associated to print either... as I accumulate data
2003 till current... I'm printing a huge list of customers who have no sales
in 2004, but show up anyway because of the zero

You can use the format property of a text box on a form or report to display
zero values as Null or blank.

--
Duane Hookom
MS Access MVP
--

OOPS... Expression shows me JAN 2004 Sales
even when there are none.. it shows $0.00...
I don't want to view $0.00 just when there is a sale

04 JAN Sales: Sum(Abs(Year([PostMonth])=2004 And
Month([PostMonth])=1)*[CommVolume])

 

[Duane Hookom]

I have no idea what "customer associated" is. You have shown us one column
expression.

--
Duane Hookom
MS Access MVP
--

I don't want the customer associated to print either... as I accumulate
data
2003 till current... I'm printing a huge list of customers who have no
sales
in 2004, but show up anyway because of the zero

You can use the format property of a text box on a form or report to
display
zero values as Null or blank.

--
Duane Hookom
MS Access MVP
--

OOPS... Expression shows me JAN 2004 Sales
even when there are none.. it shows $0.00...
I don't want to view $0.00 just when there is a sale

04 JAN Sales: Sum(Abs(Year([PostMonth])=2004 And
Month([PostMonth])=1)*[CommVolume])