SELECT TOP 1. price FROM foo ORDER BY date DESC
will give you the latest price.


>Hi All:
>
>Consider
>
>

>Item#          Date        Price
>1111           2/3/04      111.22
>2222           2/3/05      111.22
>3333           2/3/06      111.22
>4444           2/3/07      111.22
>1111           2/3/08      222.22
>
>Select Item, max(date), Price ;
>from foo ;
>group by item ;
>into cursor boo
>

>
>I want the latest price, so this would be the result:
>
>

>Item#          Date        Price
>2222           2/3/05      111.22
>3333           2/3/06      111.22
>4444           2/3/07      111.22
>1111           2/3/08      222.22
>

>
>Problem is that VFP doesn't like this and generates an error GROUP BY clause missing. How do I solve this?
>
>Thanks,
>
>Yossi