Multiple records report on 1 line

[Guest]

Let me see if I can explain what I need.

I have a table with three fields: Item, Color, and Count. The same Item can
have many entries based on Color. Say I have an item Beads and there are 10
bead records for 10 different colors of beads. I want a “single†line report
that would show the 3 records that have the highest number in the count
field. This report would be a sub-report in another report I have. What I
looking for is a report that would look something like this based on a Bead
criteria:

Red 310 Blue 95 Green 70

Although I have 10 Bead records only the top three would show in descending
count order.

Is this possible? If so any help would be appreciated.
Thanks,

 

[Guest]

You could use a multi-column subreport sorted as required and not allowed to
grow beyond displaying 3 records.

 

[Guest]

Thanks Duane,

How do you make a multi-column report? Everything I've tried places one
record below the next, not side by side.
Thanks,

 

[Guest]

Select File->Page Setup->Columns...

 

[Guest]

Thanks again Duane,

That worked great, but now I have the problem that I get all the records. I
set "Max Records" in my query to 3, but my report shows all the records. I
guess I'm still missing something.
Your help is appreciated.
Thanks,

 

[Guest]

As per my first reply regarding the subreport:
"not allowed to grow beyond displaying 3 records."