dFyr='1998'
Create SQL View TravSum as 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)
>Ok. I've duplicated the fields and have run both the select and then the query with exactly the and received the exact same results both times. But the creation of the view. Being a one time event my code looks like this.
>
>OPEN DATABASE TRAVEL
>USE LVTEMP && The name the view.
>BROWSE
>
>If you could post the exact code your using and whether perhaps you are using the view in a form.
>
I see what is happening. On the status bar when I execute the code, it says "Selected 0 records in 0.14 seconds". I immediately issued a browse and saw no data. But when I close all tables and reopen (use), then browse the data shows up. Even in the View Designer for creating a local view, I would get no data returned. This is very confusing behaviour. The code above is what I am using after being totally baffled by what the View Designer was doing to me. Thanks for the help and patience.
Mark McCasland
Midlothian, TX USA