AnsweredAssumed Answered

How to determine if the table contains records of set criteria?

Question asked by LeoCA on Nov 21, 2008
Latest reply on Nov 24, 2008 by Orlando

Title

How to determine if the table contains records of set criteria?

Post

Hi,

 

I am new to FileMaker.  We are using FileMaker Pro 8.5.  I try to determine if records exist, such as:

 

   Select Count(*) from Table where date_field1 < SystemDate-7

 

I tried create a layout and using Perform Find script, but it won't let me specify dynamic value for the WHERE criteria.

 

Any idea?  Thanks for your help!

 

LeoRA

Outcomes