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.voucheredFields (datatype):