>Sure. Just change the number used in the AS SORTKEY portion of the SELECT statement. For conditions use "1", for Medications use "2", and so on.
>

Hi Cathy:

Thank you fro your kind response.

Heres the revised code.

SELECT '4' AS SortKey, 'Family History' AS Group, ;
    PFullName AS Extra1, PAddress1 AS Extra2, PAddress2 AS Extra3, ;
    PCity as Extra4, PProvince as Extra5, PPostal as Extra6,;
    STR(PPhone) as Extra7, Marital as Extra8, Gender as Extra9,;
    ChartNum as Extra10, PatRefernc as Extra11,;
    Occupation as Extra12, WorkPhone as Extra13, Pharmacy as Extra14,;
    BirthDate AS Date1, Initvisit AS Date2, GenAssess as Date3,;
    OnCpp as Date4,;
    PHealthNum AS HealthNum, PersonData AS Descr FROM PatSummary; 
    WHERE PatSummary.PHealthNum = mHealthNum AND NOT DELETED();
  UNION ALL SELECT '5' AS SortKey, 'Past History' AS Group, ;
    PFullName AS Extra1, PAddress1 AS Extra2, PAddress2 AS Extra3, ;
    PCity as Extra4, PProvince as Extra5, PPostal as Extra6,;
    STR(PPhone) as Extra7, Marital as Extra8, Gender as Extra9,;
    ChartNum as Extra10, PatRefernc as Extra11,;
    Occupation as Extra12, WorkPhone as Extra13, Pharmacy as Extra14,;
    BirthDate AS Date1, Initvisit AS Date2, GenAssess as Date3,;
    OnCpp as Date4,;
    PHealthNum as HealthNum, PastHist AS Descr FROM PatSummary;
    WHERE PatSummary.PHealthNum = mHealthNum AND NOT DELETED();
  UNION ALL SELECT '6' AS SortKey, 'Allergies' AS Group, ;
    PFullName AS Extra1, PAddress1 AS Extra2, PAddress2 AS Extra3, ;
    PCity as Extra4, PProvince as Extra5, PPostal as Extra6,;
    STR(PPhone) as Extra7, Marital as Extra8, Gender as Extra9,;
    ChartNum as Extra10, PatRefernc as Extra11,;
    Occupation as Extra12, WorkPhone as Extra13, Pharmacy as Extra14,;
    BirthDate AS Date1, Initvisit AS Date2, GenAssess as Date3,;
    OnCpp as Date4,;
    PHealthNum as HealthNum, Allergies AS Descr FROM PatSummary; && TableA
    WHERE PatSummary.PHealthNum = mHealthNum AND NOT DELETED();
  UNION ALL SELECT '1' AS SortKey, 'Conditions' AS Group, ;
    '' AS Extra1, '' AS Extra2, '' AS Extra3, ;
    '' as Extra4, '' as Extra5, '' as Extra6,;
    "0" as Extra7, '' as Extra8, '' as Extra9,;
    '' as Extra10, OGReferenc as Extra11,;
    '' as Extra12, '' as Extra13, ''as Extra14,;
    RecordDate AS Date1, ResolvDate AS Date2, {} as Date3, {} as Date4,;
    HealthNum, HealthCond AS Descr FROM OnGoingHealth; && TableB
    WHERE OnGoingHealth.HealthNum = mHealthNum AND NOT DELETED();
  UNION ALL SELECT '2' AS SortKey, 'Medications' AS Group, ;
    '' AS Extra1, '' AS Extra2, '' AS Extra3, ;
    '' as Extra4, '' as Extra5, '' as Extra6,;
    "0" as Extra7, '' as Extra8, '' as Extra9,;
    '' as Extra10, TReference as Extra11,;
    '' as Extra12, '' as Extra13, ''as Extra14,;
    StartDate AS Date1, EndDate AS Date2, {} as Date3, {} as Date4,;
    HealthNum, Regimen AS Descr FROM Treatment; && TableC 
    WHERE Treatment.HealthNum = mHealthNum AND NOT DELETED();
  UNION ALL SELECT '3' AS SortKey, 'Consultations' AS Group, ;
    '' AS Extra1, '' AS Extra2, '' AS Extra3, ;
    '' as Extra4, '' as Extra5, '' as Extra6,;
    "0" as Extra7, '' as Extra8, '' as Extra9,;
    '' as Extra10, CReference as Extra11,;
    '' as Extra12, '' as Extra13, ''as Extra14,;
    Daterefer AS Date1, {} AS Date2, {} as Date3, {} as Date4,;
    HealthNum, Specialist AS Descr FROM Consultants; &&TableD 
    WHERE Consultants.HealthNum = mHealthNum AND NOT DELETED();
ORDER BY 1, 18 ; && 1 refers to col.1 SortKey, 18 is col.18 HealthNum
INTO CURSOR TmpData

Problem: The report Page Header has fields for Name, Address, City, Province, Postal Code, Gender, Marital Status and Phone. These are not being displayed now. Table PatSummary is the only table that has the values for these fields. How do I deal with this? I also got an "Operator/Operand type mismatch" error message.

Thanks Cathy.