Report made of a query cross table
Post the SQL of your cross tab query.
It is possible that all you have to do is add a having clause to it.
Generically that might look something like:
TRANSFORM Sum(SomeValue) as MonthlySum
SELECT Person
FROM SomeTable
GROUP BY Person
HAVING SUM(SomeValue) 0
PIVOT SomeMonthField
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Pedro wrote:
Hi everyone
It must be very simple for you guys but i can't find it: How to make a
report, made of a query cross table, but only show records that the total of
all months are diferent than zero (0). Negative and positive values.
That report sums the sales for each person, each months and i want to know
who sell and who's not selling.
Tks in advance
Pedro
|