>>>>VFP 3.0b, Win 95. I have the following code:

>>>>
>>>>dFyr='1998'
>>>>SELECT Accounts.account, Accounts.allotment, ;
>>>>  sum(Transact.amount) as "AMOUNT", ;
>>>>  sum(Transact.regfee) as "REGFEE", ;
>>>>  Transact.vouchered, Transact.actid, Transact.fyr ;
>>>> FROM travel!transact, travel!accounts ;
>>>> WHERE Accounts.actid = Transact.actid ;
>>>>   AND Accounts.fyr = Transact.fyr ;
>>>>   AND (Accounts.fyr = ?dFyr) ;
>>>> GROUP BY Accounts.account, Transact.vouchered ;
>>>> ORDER BY Accounts.account, Transact.vouchered

>>>>
>>>>Fields (datatype):
>>>>
>>>>Account (C), Allotment (N), Amount(N), RegFee (N), Vouchered (L),
>>>>ActID (N), FYr (C)
>>>>
>>>>As given above the sql returns the correct information. But when I put "Create Sql View ViewName As" at the beginning of the statement, it returns no rows. ?????
>>>>

Just out of curiousity, did you try it without the SUMs and GROUP BY? I have a view I first did in vfp3 nearly identical, but without those, and it (still) works fine...