Queries - stop repeating?

[lecoughlin]

I have the following query (for example):

countofstates color
3 red
8 blue
7 orange
2 purple
9 yellow

I would like to display this table on a report, but when I do it
repeats 6 times. How do I only get this information to appear once?

Thanks in advance.

 

[Al Campagna]

Try a Totals query...
Color States
GroupBy Count

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."