Hi , I am trying to extract data from body fields to place in summary parts and then perform a comparison calculation on the data. The script steps work ( or don't) like this:

Perform Find (Department)

Sort (Job Card No.)

Go to First record

Copy(Define Field=Job Card No.)

(the fields above are in the body)

Paste(define field=First job Card)

(This field is in the summary)

Go to last record

Copy(Define Field=Job Card No.)

(this field is in the body)

Past (Define Field=Last Card No.)

(This field is in the summary)

I then want to subtract the first card No. from the last card No.+1 and compare this with the record count which should be equal. This would tell me if any job cards were missing, however the data does not get pasted. I have tried to add a set field to Firts card No. etc but it still does not work. Any Ideas please

Oyseka

You can't paste into a field in a subsummary part. You can do what you want using a self relations based upon Department (almost). Create a relationship with Department <--> Department. Then create the following calculated fields:

CardCount (calculation, number) =

Max (SelfByDepartment::Job Card No.) - Min(SelfByDepartment::Job Card No.) + 1

***remember, if you have two cards, "1" and "2", subtracting 2-1 gives 1 and there are two cards, hence, the + 1***

RecordCount (calculation, number) = Count(SelfByDepartment::Job Card No.)

The thing you didn't tell me is what a set of cards represents: One Week? One Month? You may need to base your relationship on a field which combines the Department with the Month/Year or Week/Year to isolate the appropriate set of records. Remember that a Sum(), Min(), Max() or Count() function operates over all related records in the file. It doesn't care about the found set of records.

-bd