Crosstab Query With Parameters

[geekette]

Hi,

I have a crosstab query that is linked to a select query. The select query contains parameters that are linked to a form where a user can enter dates.

When I try to run the crosstab query I get an error message "Microsoft Access does not recognise.... (the name of the date field on my form). I've tried resolving this by entering the name of the form field into the queries parameter.

But I now get a different message saying "Incorrect bracketing". I've entered the full name of the form and field [Forms]![frm_ResourcePlanner]![Report_StartDate] and am not sure why I am getting this message?

The SQL for my Crosstab query is below:

PARAMETERS [Forms]![frm_ResourcePlanner]![[Report_StartDate] ] DateTime;
TRANSFORM Sum(qry_Availability_Centrac_P2.Number) AS SumOfNumber
SELECT qry_Availability_Centrac_P2.Date, qry_Availability_Centrac_P2.Report_Name, qry_Availability_Centrac_P2.Code, Sum(qry_Availability_Centrac_P2.Number) AS [Total Of Number]
FROM qry_Availability_Centrac_P2
GROUP BY qry_Availability_Centrac_P2.Date, qry_Availability_Centrac_P2.Report_Name, qry_Availability_Centrac_P2.Code
PIVOT qry_Availability_Centrac_P2.Interval_Start;

Any help would be greatly received :O)

 

[bdb04]

It looks like you have 2 sets of brackets around Report_StartDate.

[Forms]![frm_ResourcePlanner]![[Report_StartDate] ]

Should be: [Forms]![frm_ResourcePlanner]![Report_StartDate]

 

[geekette]

Hi - thanks for your reply - it was a typo I'd made when posting my question. Even with the correct bracketing it still gives me the same error?