MaxRecords

[PedroSantos]

Hi, is it possible to force a form to display only, say, 10 records at maximum? I've trying to use maxrecords property, but i guess i must playin' around with ADO and stuff like that, and I just can't do that... I'm creating a database to a work for school, so, my teacher didn't tech that kind of things (actually, he doesn't teach anything... oh well...)
so, i just don't know how to use RecordSet objects...
is there any other way?
thanks in advance

Pedro Santos

 

[David R]

You might be able to use a SELECT TOP 10 query...

 

[PedroSantos]

No, that's not what i want, because I wanna be able to order the results by one field, and then, by other field. So, the query must be done using all the records, and then sorted properly...
thanks anyway

Pedro Santos

 

[Rich]

Then use a second query which selects the top10 from the first.