8 Replies Latest reply: May 28, 2014 8:17 AM by Michael Solomovich RSS

    Check if field was ever a certain value

    Matt Maino

      Hi, I'm working with a set of data that contains information pertaining to accounts. Each account has a row of data that represents the the account's standing at the end of the month. Since my database has been collecting data on these accounts for several months, each account has several rows of data. I am interested in writing a script that would allow me to go check if a certain field was ever a specific value for each account. For example, say I have 10 rows for account 1 - I would like to look at a specific field in all of those 10 rows and determine if that field ever contained 'x' as a value. Is this possible? Thank you.