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. ?????

Any ideas?

TIA!