cross tab query, different items with a total

[pianolady]

i need a crosstab query
apples oranges bananas
10 20 30

I used to do it all the time, but the cross tab query

 

[KARL DEWEY]

A crosstab query want at least three fields but it looks as if you only have
two. There is a way to do it with only two.
Post what your table looks like -- field names and data type. Also some
sample data.