I have a table with a text field [Field_B] containing values between 00001 and 01000.

In a script I am performing a find to restrict the recordset to only include records containing certain criteria in another field [Field_A].

After this is complete I then am trying to use the MAX function to return the highest value in Field B that remains in the recordset. However it seems to be picking the lowest number.

For example. this is what I have left after a Find

Field_A     Field_B

A           00250

A           00375

A           00400

MAX (table::Field_: returns 00250

Any ideas where to look?

I believe you may have a context issue. If you are in TableA, Max(TableA::Field_: will return the value in Field_B of the current record. You need to use a summary field to get the max value of the found set.

If you were in another table (i.e. table occurrence), Max(TableA::Field_: would return the max value of the related set in TableA.

comment to the rescue once again.. anyone else do any work around here? :

thanks again comment.. you are rapidly becoming my FileMaker BFF :