Report in Access

[Cliff]

Trying to get a quick little report that I can take to the track listing only top 3 kRat horses in each race.

Have the query set up with nRace ascending and rKrat ascending and everything looks fine there.

However, once I go to my report (using the query as the source), the horses do not show up in 1, 2, 3 ascending rKrat order. Am not real sure what kind of order they print out in. The top 3 are there and listed by race, just not in order.

Any suggestions what I need to do in the report to get them to show correctly?

Here is first couple of races at LS of what I'm getting:


1 10 Fitzroyal (k2)
1 1 Catalissa (k1)
1 7 Term Sheet (k3)

2 2 Cowgirl Stuff (k3)
2 3 Flower Mound (k1)
2 8 Mary Sue (k2)


Thanks for any suggestions,
Cliff

[Donnie]

Cliff....go up to your toolbar in the report Design View, find the Sorting and Grouping button and click it. Make sure the first field is the Track code, the second field is Race No. and the third field is KRat. Make sure ascending is chosen next to each. Also make sure that the KRat field in the table is set to number and not text....if it is text it wil sort the 10's 11's and such beforethe 2, 3, 4 order.

Hopefully this will help!

[Cliff]

Donnie,

That fixed it.

Thank you, Sir.

Cliff