cross tab query, different items with a total

P

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
 
K

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.
 
Top