call specific start date in crosstab query

[tngirl]

I am working in a cross tab query for the first time so I appreciate all the support you can provide.



The purpose of my query is to provide a rolling 12 month report with data by month. The column headings are the months. Unfortunately I inherited this database and it is not formated the best way possible and the table I'm using actually has a field name "date" so maybe that is the issue, I'm not sure. I read in a previous post to add a where clause in the query to prompt for the start date..

Field = Date
Table = QualityFiles
Total = Where
Criteria = >=[startdate]

This is not working at all for me, so then I thought I would lauch a form requesting the start date so I used the form name and it would not work either.

Criteria = >=[forms]![Report Date Start]![StartDate]

Can you help to show me what I'm doing wrong in my crosstab query? Thank you

[June7]

Search forum and web on topic dynamic crosstab.

http://support.microsoft.com/kb/328320

http://www.blueclaw-db.com/report_dy...stab_field.htm

http://www.access.hookom.net/Dynamic...rosstabRpt.htm

http://allenbrowne.com/ser-67.html

[tngirl]

I've read these posts and they are not helping me at all. Is a crosstab query not the best option to gather this data? Thank you,

[June7]

Why don't they help? Those are really comprehensive references. What have you tried? Post your attempted SQL.

If you want to pivot the data, then CROSSTAB is query tool for that purpose.

However, as the Allen Browne article indicates, filter criteria in CROSSTAB works differently. Did you try the technique described?

[tngirl]

Thank you, I order Microsoft Office Access 2007 Inside Out and it came last night. I was able to look up the declare the parameter option that was referenced in the link you provided. Thank you for your help :-)