I am having trouble getting the sort I need for a report. I am probably overthinking it or maybe should go about this in an entirely different way. My table contains well names with drilling rigs assigned. Some, but not all will have 2 rigs assigned. Some rigs may the 1st rig on one well and second rig on another well. Some rigs may only be second rig on job. I need to print a report of the schedule. Prior to this all wells had only one rig and the report worked out great, but with the assignment of second rigs - I am confused. Both rigs are associated with a well and on the report I need the well to show up twice if it has 2 rigs - once with the Rig1 sort and again on the rig2 sort if hit has a rig2. So the sort would be all Rig1 first (alpha by rig) then by sequence. After rig1's will start Rig2's, again sorting rig alpha, then by sequence. I sure hope this makes sense to somebody.
I have attached a sample of the table I have and the report layout I am looking for.
THANKS!
I have attached a sample of the table I have and the report layout I am looking for.
THANKS!