Transpose like (Crosstab) query

[Guest]

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!

 

[[MVP] S.Clark]

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