Excluding specified counts

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

Guest

I have a query showing LogIn_Acct and what their New_Login accounts were
changed to. There will be New_Login accounts that have only one old
LogIn_Acct and some New_Login accounts have as many as 6 old LogIn_Acct.

In my report i have the New_Login in a header and the details for that are
all the old LogIn_Acct . In the header where New_Login is displayed, I have
a count to show how many LogIn_Acct fall under then New_Login.

The thing that I want to do now, is to only print out Counts that are
greater than a specified number. For example > 5.

Any suggestions would be appreciated greatly. THANKS!
 
Archness said:
I have a query showing LogIn_Acct and what their New_Login accounts were
changed to. There will be New_Login accounts that have only one old
LogIn_Acct and some New_Login accounts have as many as 6 old LogIn_Acct.

In my report i have the New_Login in a header and the details for that are
all the old LogIn_Acct . In the header where New_Login is displayed, I have
a count to show how many LogIn_Acct fall under then New_Login.

The thing that I want to do now, is to only print out Counts that are
greater than a specified number. For example > 5.
Click to expand...


If you want some data excluded from the report, you should
use a criteria in the report's record source query. In this
case I think you might want something like:

SELECT New_Login, LogIn_Acct
FROM table
WHERE (SELECT Count(*)
FROM table As X
WNERE X.New_Login = table.New_Login) > 5
 
Back
Top