Wanted three latest (dates) for memo field

[datahead2009]

I just need a way to display the "top three records" of a table that contains a date, user id, and memo field. I want these records by user. Output: User, Date, Memo field.

 

[lbass]

The three latest for each user?

-LB

 

[datahead2009]

Yes, the three latest memo fields for that specific individual( by Memo Date ). Report is run for each individual. By the way I tried ranking in SQL. The SQL ranks for all people, not just one.

I tried crystal reports summary, does not work for memo fields.

 

[lbass]

You could do a top N statement by using Add Command and entering something like:

select top 3 table.`date`, table.`user ID`, table.`memo`
from table
where table.`user ID` = 123
order by table.`date` desc

Or you could write a conventional report where you limit the records to one user in the selection formula, sort in descending order by the date field, and then use a suppression formula on the detail section of:

recordnumber > 3

-LB

 

[datahead2009]

lbass,

Thanks for the info. I figured out the same thing as your first choice ! Way to go. Thanks for your help.

The only thing I did different was pass a parameter (userID) to the SQL command, utilizing the Top N method. !