Cross rabular query

[Sarah]

Can you create a cross tabular query without calculations? I want to create a
cross tabular query with data that I want left raw, I just want to display
the data in a cross tabular format. Is it possible? Thanks

 

[Allen Browne]

A crosstab query must have a field that supplies the column headings, and a
field that supplies the values. It normally has 1 or more row headings
(output as fields.)

Often the value is aggregated (sum or count or ...), but it doesn't have to
be. If there is only one value to show at each point in the matrix (of if
you don't care which value is shown), choose First on the Group By row in
query design under the field that supplies the value. JET is then free to
choose the first thing it can find as the query runs, and show that.