RECORDS GREATER THAN A SPECIFIC SUM

[zupko]

I would like to bring in records that are greater than a total of 15. I have the following expression which gives me the total number of records:

=Sum([CountOfDAYCODE])

Now if I could just get the records in the Report to list those that total more than 15 records any records 15 or less would not be displayed.

 

[link9]

WHERE CountOfDAYCODE > 15

or WHERE (SUM([CountOfDAYCODE])>15)

should work

 

[Cagliostro]

As i believe, you can put sum in having expresion.
select a,b,sum(*) from xxx
group by a,b
having sum(*)>15
John Fill

http://ournet.md/~ifilipski/1c.bmp

ivfmd@mail.md