I would like to display the following date in the format shown below it – in a query/form or report ...

ITEM modified
Widget1 5/15/06
Widget1 6/15/06
Widget2 3/13/05
Widget2 6/14/06
Widget2 7/23/06
Widget2 8/15/06
Widget3 3/15/05



___________1 _____2______3_______4_______5
Widget1 5/15/05 6/15/06
Widget2 3/13/05 6/14/06 7/23/06 8/21/06
Widget3 3/15/06
Widget4

To pivot the dates that way, you would need to assign sequence numbers to them. If you search the forums here you can find suggestions on how to generate numbers in a query. You can then use the crosstab query builder to build a crosstab from the query rather than the table.

Thanks, I think you mean that the query would need to return the data as shown below. I did a search for generating numbers and don't see anything that would do this...did I understand you correctly?; any other clues thanks

newquery

ITEM, modified, index
Widget1, 5/15/06, 1
Widget1, 6/15/06, 2
Widget2, 3/13/05, 1
Widget2, 6/14/06, 2
Widget2, 7/23/06, 3
Widget2, 8/15/06, 4
Widget3, 3/15/05, 1