Report Generation

Thank you for your suggestions. i have tried to attach the file ,but it seems to be deleted for some reason however , I have managed to creat a combined query for all 22 diagnosis based on the 12 criteria , when I run it it shows exactly what I want , now when I try to creat a crosstab query out of that combined query , its gives me and error msg that the access database engine cant recognize [ Forms]![Report Generation]![StartDate] as a field name or expression.

(Report generation form is the form with dat controls), while its fully working as its in the combined query.

please find the attached screen shots and the combined query .

I will appreciate any help I get.

thanks 

Combined Query:

SELECT Diagnosis, SUM(IIf([Group]="GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [GPOC, Female, =5, New Visit], 
SUM(IIf([Group]="GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [GPOC, Female, =5, Re-Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=4 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Female, =4, New Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=4 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Female, =4, Re-Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Female, =5, New Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Female, =5, Re-Visit],
 SUM(IIf([Group]="GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [GPOC, Male, =5, New Visit], 
SUM(IIf([Group]="GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [GPOC, Male, =5, Re-Visit],
 SUM(IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=4 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Male, =4, New Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=4 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Male, =4, Re-Visit],
 SUM(IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Male, =5, New Visit], 
SUM(IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)) AS [Non GPOC, Male, =5, Re-Visit], SUM(
        IIf([Group]="GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=4 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=4 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Female" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=4 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=4 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="New Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0) +
        IIf([Group]="Non GPOC" AND [Gender]="Male" AND [Age Group]=5 AND [Visit Type]="Re-Visit" AND [Visit Date] BETWEEN [Forms]![Report Generation]![StartDate] AND [Forms]![Report Generation]![EndDate], 1, 0)
    ) AS Total
FROM Data
WHERE Diagnosis IN ("Malaria", "URTI/LRTI", "Typhoid Fever", "AWD", "Dysentery", "Skin diseases", "Eye diseases", "STDs", "UTI", "Asthma", "PUD", "Arthritis", "Hypertension", "Diabetes", "Injuries & Accidents", "Burn", "CO Poisoning", "Others")
GROUP BY Diagnosis;

attached is a screenshot of my table and the other screenshot is when I run the above code after I enter the date range in report generation form.