Monthly Display On Crosstab

[vise]

Hi all,
I have a crosstab query working with the following fields: Line Number, Shift, and # or errors. I want to add a time field so that it display those values monthly. Any ideas?
Thanks,
-vise

 

[dhookom]

Add your time field to the crosstab and calc on it like:
Format([YourDateTime],"yyyymm&quot
Then use it as a row or column heading depending on what you want.

Duane
MS Access MVP

 

[vise]

I get the following Error message when i put that in my crosstab.
Data type mismatch in the criteria expression.
.. what does this mean?

I entered the following
Field: Time
Table: Master
Total: where
Criteria:
Format([YourDateTime],"yyyymm&quot
.. is that correct?
Thanks.

 

[dhookom]

The expression goes in the Field, not criteria.
YrMth:Format([Time],"yyyymm&quot

BTW: Time is not a good name for a field since it is a function name. I would rather maintain one thread on this so please use the thread in REPORTS.

Duane
MS Access MVP