I tried your suggestion to no avail. My SQL statement now looks like this:

SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
FROM price!pricelist;
GROUP BY pricelist.ITEM;
ORDER BY pricelist.DATE DESC;
INTO TABLE temp.DBF

Any other suggestions???


>Strange behavior.
>May I suggest:
>1. Swap the order of the GROUP BY and ORDER BY clauses.
>2. Refer to the GB and OB fields by number as in
>
>SELECT .... GROUP BY 1 ORDER BY 4 .....
>
>Good Luck.
>
>>I have the following SQL statement:
>>
>>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
>> FROM price!pricelist;
>> order by pricelist.date desc;
>> GROUP BY pricelist.ITEM;
>> INTO TABLE temp.DBF
>>
>>The results do not show an item number:
>>
>>T97000-503
>>
>>but it will show an item number:
>>
>>T97000-503R
>>
>>What may I be doing wrong?
>>
>>Jeff Pearce