Mark,
I have no idea what the real problem is <g>, but if you want to play around, you could put it into JOIN form. It shouldn't make any difference, of course. Strange.
Hank
>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!