>I have the following SQL statement:
>
>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
>FROM price!pricelist;
>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?
How certain are you that T97000-503 isn't marked for deletion?
Paul M.
MCSE/MCSA/MCT/MCP+I, A+, Network+, I-Net+
Nil carborundum illegitimi.