User defined Parameter on Crosstab query

[jmersing]

I'm having a problem adding a parameter to a crosstab query. I'm starting to think it is not possible. Here is what I'm doing

I have a table with three columns I want to display, event type, event date, and number of events on that date.

Si I'm transforming the event date into
Format(tblOut.CallDate,"dddd") AS EventCount

Then I want to use a crosstab query to group and count the data by the day of the week. So the result would be a row header of the event type, the columns would be Sunday through Saturday, and the value would be counting the dates for each day of the week. Here is the whole query

When trying to do it on a form field
SELECT tblOut.CallDate, tblOut.RelatedEvent, Format(tblOut.CallDate,"dddd") AS OutDate
FROM tblOut
WHERE (((tblOut.RelatedEvent)=[forms]![frmnew]![relatedevent] & " "));

When trying User defined

SELECT tblOut.CallDate, tblOut.RelatedEvent, Format(tblOut.CallDate,"dddd") AS OutDate
FROM tblOut
WHERE (((tblOut.RelatedEvent)=[Type in the related event]));

 

[jmersing]

Nevermind!

I forgot that I had to add the fixed column names to the property of the query. Thanks anyway!