>>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!
>
>Ok. I've duplicated the fields and have run both the select and then the query with exactly the saPOST /cgi-bin/vfpwebn.exe HTTP/1.0
>Referer: http://www.levelextreme.com/cgi-bin/vfpwebn.exe?2,16,62054
>Connection: Keep-Alive
>User-Agent: Mozilla/3.0C-NC320 (Win16; U)
>Host: www.levelextreme.com
>Accept: image/gif, image/x-xbitmap, image/jpeg, iing? Is this part of a form? etc..

I think your reply got jumbled here. What I did was open my data base and used the view designer to create a local view (VFP 3). When the view failed to work, I copied the SQL code to a .PRG and started to tinker with the code. Nothing has worked so far. So in the interem, I have removed the "Create SQL View" part and just create a cursor on the fly. Bummer.