Transpose like (Crosstab) query

I would like to perfrom a Transpose like query where the intersection is an
actual field rather than an expression.

For example, part, defect and date. I would like the part as row heading,
defect as column heading and the actual date of occurrence at the
intersection, rather than the number of dates.

Does anyone know a way to due this without using VBA code?

Thanks for your help!

Use Max(DateField) for the Value in the xtab.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"Lee Hunter" wrote in message
...
I would like to perfrom a Transpose like query where the intersection is
an
actual field rather than an expression.

For example, part, defect and date. I would like the part as row heading,
defect as column heading and the actual date of occurrence at the
intersection, rather than the number of dates.

Does anyone know a way to due this without using VBA code?

Thanks for your help!