GroupByX Sum CounfOfX but show only the ones more than a given val

  • Thread starter Thread starter vepha
  • Start date Start date
V

vepha

Hi Everyone,

I want to be prompt to give a value for the Sum of CounOfX. For example
query should ask me to give a value and show me only the group sums equal or
more than that given value. I hope i could explain it.

SELECT qry_d2.Kunde, Sum(qry_d2.CountOfKunde) AS SummevonCountOfKunde
FROM qry_d2
GROUP BY qry_d2.Kunde, Format$(qry_d2.Erfassungsdatum,' yyyy'),
qry_d2.CountOfKunde, qry_d2.KundenNr
HAVING (((qry_d2.Kunde)=IIf([Kunde] Is Not Null,[Kunde],"leer")) AND
((qry_d2.KundenNr)=IIf([KundenNr] Is Not Null,[KundenNr],"leer")));

Thanks you all very much in advance
Vefa
 
Parameters [More Than What Value?] Long;
SELECT qry_d2.Kunde
, Sum(qry_d2.CountOfKunde) AS SummevonCountOfKunde
FROM qry_d2

WHERE qry_d2.Kunde=IIf([Kunde] Is Not Null,[Kunde],"leer") AND
qry_d2.KundenNr=IIf([KundenNr] Is Not Null,[KundenNr],"leer")

GROUP BY qry_d2.Kunde, Format$(qry_d2.Erfassungsdatum,' yyyy'),
qry_d2.CountOfKunde, qry_d2.KundenNr
HAVING Sum(qry_d2.CountOfKunde) > [More Than What Value?]

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
That was it.
Thank you very much John
--
" Dont mess around so much, do something usefull like making the world a
better place, like helping people who really need help, like being the ace
instead of an empty face! "


John Spencer said:
Parameters [More Than What Value?] Long;
SELECT qry_d2.Kunde
, Sum(qry_d2.CountOfKunde) AS SummevonCountOfKunde
FROM qry_d2

WHERE qry_d2.Kunde=IIf([Kunde] Is Not Null,[Kunde],"leer") AND
qry_d2.KundenNr=IIf([KundenNr] Is Not Null,[KundenNr],"leer")

GROUP BY qry_d2.Kunde, Format$(qry_d2.Erfassungsdatum,' yyyy'),
qry_d2.CountOfKunde, qry_d2.KundenNr
HAVING Sum(qry_d2.CountOfKunde) > [More Than What Value?]

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

vepha said:
Hi Everyone,

I want to be prompt to give a value for the Sum of CounOfX. For example
query should ask me to give a value and show me only the group sums equal
or
more than that given value. I hope i could explain it.

SELECT qry_d2.Kunde, Sum(qry_d2.CountOfKunde) AS SummevonCountOfKunde
FROM qry_d2
GROUP BY qry_d2.Kunde, Format$(qry_d2.Erfassungsdatum,' yyyy'),
qry_d2.CountOfKunde, qry_d2.KundenNr
HAVING (((qry_d2.Kunde)=IIf([Kunde] Is Not Null,[Kunde],"leer")) AND
((qry_d2.KundenNr)=IIf([KundenNr] Is Not Null,[KundenNr],"leer")));

Thanks you all very much in advance
Vefa
Click to expand...
Click to expand...
 
Back
Top