dbTalk Databases Forums  

Report Criteria

comp.databases.filemaker comp.databases.filemaker


Discuss Report Criteria in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
inowbelieve@gmail.com
 
Posts: n/a

Default Report Criteria - 10-24-2006 , 02:13 PM






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?


Reply With Quote
  #2  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Report Criteria - 10-24-2006 , 02:35 PM






<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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.