Crosstab Query

[Al Mackay]

I would like to be able to do the following, however not been able to
work out how to do this or find a similar query/answer through
searching the groups.

Have two series of data within one table:
Date Opened
Date Closed

Each record also has a unique key number, e.g.

# Date Opened Date Closed
123 12/03/03 15/05/04
234 14/03/04

What I want to be able to do is run a query that would either create a
table directly or alternatively a chart that will group the two series
of data (date opened/closed) by Month / year.

Is this possible in access @ all? appreciate any help that you could
offer on this. Many Thanks, al. ( (e-mail address removed) )

 

[Duane Hookom]

You should be able to set the row heading to your "#" field and your column
heading to your "open/closed" field and the value of your date field.

Next time it would help if you posted the field names and some sample data.