Is a multi date result possible?

[julius1]

I have a query that lists the date of activity on a record, what I am looking for is is it possible to show on the query result multiple dates? For example:
I have a DS-1 system with 24 channels on it. I have it set to record by macro the date of occupancy to a date field. I have that date field in my query. It lists all channel activity for the system. My question with that in mind is:
can all or even just the last 3 dates of activity be displayed? I can get 1 date but can I get more then one date to display? If I have activity on today the 4th, and I also had activity on the 3rd, I am trying to get both dates to diplay. They are stored in the table, so I can see all of the activity, but I don't know if it can be done to have the dates of activity show or even just the last 3??
if any one has any ideas please fell free to throw them my way!

 

[mpastore]

you can do this with the TOP predicate in your sql statement. Along with the order clause you can see last n records from a data set. Check help on this for examples.

Mike Pastore

Hats off to (Roy) Harper