How to use SYNCSORT to Create a new file only if the original file has records more or equal to 250 records. I see that the COUNT can be used but not sure if that can be used staraight in the comparsions .

This has to be done for 2 siutations.

Situation 1 file records:

Original file size is 500 bytes VBA format

There is 1 record/account.

No sorting of records is needed.

Sampling of records will be as below

1 SZ1 AC#1 AAA..........

1 SZ1 AC#2 BBB...........

1 SZ1 AC#3 CCC....

1 SZ1 AC#4 DDD......

Situation 2 file records:

Original file size is 500 bytes VBA format

No sorting of records is needed.

Each account will have 5 records.

There are 5 record/account, when counting they have to be grouped or if COUNT can be used,will have to divide by 5 with total count.

Sampling of records will be as below

1 SZ1 AC#1 AAA..........

1 SZ2 AC#1 ABA...........

1 SZ3 AC#1 ACA..........

1 SZ4 AC#1 ADA......

1 SZ5 AC#1 AEA.........

1 SZ1 AC#2 CCC....

1 SZ2 AC#2 CBC....

1 SZ3 AC#2 CCC....

1 SZ4 AC#2 CDC....

1 SZ5 AC#2 CEC....

1 SZ1 AC#3 DDD......

1 SZ2 AC#3 DDD......

1 SZ3 AC#3 DDD......

1 SZ4 AC#3 DDD......

1 SZ5 AC#3 DDD......

Any help is appreciated.

Thank You.