calculation field seems right but isnt?

[LoneReaper]

If ( Last (PatternCount (RW_BookFormat , "HDRS|" )) , "" , "HDRS|

[-Queue-]

It's failing on you because of the Last( ) function. Last( ) returns the value of the largest nonempty repetition of a repeating field or the value of the last related record's field, according to the sort order specified in a relationship. Neither case seems to apply to your situation.

What do you mean by 'last record'? The last record in the file? The last record preceding to the current one? The last record which was entered (locked)?

[LoneReaper]

i found another way thanks! I am using a program called Autoit, it is so cool.

hiddensoft.com