Well, I just thought I could save an re-enter the View Designer. Using the Design screen I've created the following SQL statement. The SQL statement runs and gives me the desired results. I have now found out that regardless if I make a manual change or not, the View Designer will not reload the query. It gives the message mention in the previous e-mail. VFP makes created that SQL based on my selections and mades no 'complaints' when saving the view but it will not load. Any ideas?

SELECT Itemmaster.Commodity,;
SUM(Lnai.Qty) AS fg_qty,;
SUM(Lnai.Cost) AS fg_xferamt;
FROM {oj dbo.tblLNaiTransactionLog Lnai;
LEFT OUTER JOIN dbo.ItemMaster Itemmaster ON Lnai.KeyField = Itemmaster.KeyField} ;
WHERE Lnai.datercvd BETWEEN '04/04/04' and '05/01/04' AND;
(Lnai.transactiontypeid = 3 OR Lnai.transactionid = 16);
GROUP BY Itemmaster.Commodity;
ORDER BY Itemmaster.Commodity