report shows fields with 0.00 vlaues

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

Guest

I have a table with sales from 2003 thru current April 2005
I have designed a query and report to show current month, 05 YTD and 04YTD
but the report priints ALL customers... I don't want to see any customers
with 0 sales
I tried <>0 as a criteria... but then the sum did not include any credits
(such as -15.00 credit)
This is my expression for 05YTDSales:
Sum(Abs(Year([PostMonth])=(2005))*[CommVolume])

HELP !
 
Claudia:

It's hard to tell exactly without seeing the entire query however, if you
are using a GROUP BY SQL statement you may want to add a HAVING statement to
filter out the 0 sales.

For example:

HAVING Sum(Abs(Year([PostMonth])=(2005))*[CommVolume]) <> 0


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a table with sales from 2003 thru current April 2005
I have designed a query and report to show current month, 05 YTD and 04YTD
but the report priints ALL customers... I don't want to see any customers
with 0 sales
I tried <>0 as a criteria... but then the sum did not include any credits
(such as -15.00 credit)
This is my expression for 05YTDSales:
Sum(Abs(Year([PostMonth])=(2005))*[CommVolume])

HELP !
 
Tried your suggestion... rec'd invalid syntax error... operand without an
operator
I am using the expression in the query grid...
 
Back
Top