do not show zero values in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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])
 
You can use the format property of a text box on a form or report to display
zero values as Null or blank.
 
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

Duane Hookom said:
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
--

Claudia said:
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])
Click to expand...
Click to expand...
 
I have no idea what "customer associated" is. You have shown us one column
expression.

--
Duane Hookom
MS Access MVP
--

Claudia said:
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

Duane Hookom said:
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
--

Claudia said:
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])
Click to expand...
Click to expand...
Click to expand...
 
Back
Top