Help on a Query

[RaceProfiler]

This will be my 1rst time experience in a few areas: 1rst time with Ken @ HTR, 1rst time utilizing a Message Board & 1rst time working with a database (Access 97)! Which brings me to my question? My database is 188,000+ bytes... exceding attachement max.

My database contains 2 fields: Field #1-morning line odds & Field #2-final post time odds. I want to run 2 seperate queries: Query #1 was a complete success! ... it seperated my records into 3 groups based upon Field #2, criteria follows:

Asceending
<=4.9
>=5.0 And <=11.9
>=12.0

Query #2 is identical to Query #1 with one distinction ... I want the 3 seperate groups created in Query #1 to stay exactly the same but I want records within each of the seperate groups in ascending order based upon Field #1.

Any help would be greatly appreciated! I can e-mail you with an attachment of the database if that would help?

Thanks, Liam

P.S. I had the great opportunity to consult with Ken Massa in person ... an Awesome racing-oriented programmer ... and a Genuinely nice guy!!

[Rick]

You could create a new field in your second query that had values of 1, 2, or 3 based on the odds. You could then do a primary sort on this field with a secondary sort on the final odds field.

That's the way I would start trying to get it to work. If that didn't work I would continue on from there.

That's from a seat of your pants type of Access guy. Someone that knows what they are doing can probably give you an easy way of doing it.

[Rick]

On top of the above, you can probably do it all in your first query.

After further review: (I just opened Access)

I don't know how you did the first part.

If you don't get it done, send me a small sample of db with query.

ricks@homebased2.com