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.
Returns the position of the field value value found in the field fieldname (by load order). If value cannot be found among the field values, 0 is returned. fieldname must be given as a string value, e.g. the field name must be enclosed by single quotes.