<inowbelieve (AT) gmail (DOT) com> wrote:
Quote:
I have a sub-total report that displays when a access-point logs a bad
user login. I need to only report on any user who has 10 or more bad
logins. How do I add that criteria to the report? |
Table users, table logins. Create a relation based on two criteria: user
IS is equal and login is bad. In the users table, create a calc field
'count(LoginTable::Logins). That should give you the number of bad
logins per users. Now search this field for results > 9.
I have feeling here are more elegant ways, though.
--
http://clk.ch