insert function

J

Joyrider

i have a list of song record in a query. is there anyway that i can move the
5th song record to the top of the list using a action query or VB?
 
B

BL VDA via AccessMonster.com

I'm not sure what you mean.
Do you specifically want the 5th record to go on top ?
Normally in a query this is done by the sorting, so you could add a value
to a field (SortOrder), and requery afterwards.
But I don't really see why you would need that ?
 
Top