Hi,
I have a table with a list of items and dates. Each item can have multiple dates which are displayed as a second entry with a matching item number.
I would like to make a query to display the dates on a single line (next to the item number) much like a crosstab query would display. The problem i have is that i would like the crosstab to count the dates. i.e.:
Row Heading: Item number
Column Heading: 1st, 2nd, 3rd, 4th, 5th
Value: Date
Please could you tell me if this is possible?
Regards
I have a table with a list of items and dates. Each item can have multiple dates which are displayed as a second entry with a matching item number.
I would like to make a query to display the dates on a single line (next to the item number) much like a crosstab query would display. The problem i have is that i would like the crosstab to count the dates. i.e.:
Row Heading: Item number
Column Heading: 1st, 2nd, 3rd, 4th, 5th
Value: Date
Please could you tell me if this is possible?
Regards
