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