Access Cross Tab reportng ?

[Kevin]

I have a table with the following sample data.

Machine Date Title
======= ===== ======
MC1 1/4 T1
MC2 1/4 T2
MC1 2/4 T3
MC3 2/4 T4

Now I'd like to generate a report as follows:
Machine Date
1/4 2/4
MC1 T1 T3
MC2 T2
MC3 T4

This looks like a cross-tab report. However, the value is
a text field rather than a calculated field. We can
assume the record value is unique. Is there any trick we
can make to generate the "matrix" report ?

Many thanks,
Kevin

 

[Perry]

In the Crosstab Query wizard, try to use First or Last
criterium when you get to the datagrid tab of of the wizard.

Krgrds,
Perry