Selecting the top ten records - PLEASE HELP - Thanks 1

[LDG1234]

Hi guys

Just a simple one for you today.

I have a date actioned column and I work out how long a file has been open by subtracting it from Date(). This gives me the number of days.

What I need to do is to run a query to select the 10 oldest items in the recordset....can this be done???

Thanks in advance for any assitance that can be offered.

Lloyd Gozzett
Process Developer

 

[mymou]

Hi Lloyd

Check out 'Display only the highest or lowest values in the query's results' in help - that should do it for you.

Stew

 

[evalesthy]

If I understand you correctly - couldn't you just sort the records in the query on 'DateActioned' in Descending order (oldest first) and then use TopValue to return top 10 records?
This could be done through a recordset also if necessary.