How do I do this Cross Tab

[Ste4en]

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

 

[Ste4en]

STILL NEED HELP - Cross Tab & Number Generation

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