Cross Tab to show actual values

[Access_Help]

I do not wish to show a summarised value for the row and heading in a cross tab query, I want to display the actual value.

The value is a number field.

How can this be achieved?

 

[theDBguy]

You could try using Min or Max or First or Last.

 

[CJ_London]

depends on your data but suggest also include the primary key or other unique identifier for a record as a row heading