Aye, that works. Thanks Sergey.
Can't say I've ever fully got to grips with the Group By clause. Help is very sketchy about, say, how YOU discerned that column was necessary.
>You're missing
jobheads.JobID in the GROUP BY.
>
>>
>>"SQL group clause missing or invalid" under engine 90
>>
>>Now remember this was just a "first cut" stab at the SQL and I've trried many permutations, including "group by 1, 4"
>>
>>
>>Select JobAct.OurInvID, jobheads.JobID, SUM( jobheads.Quantity) as Booked, SUM( jobact.hours) as Charged, JobHeads.LabourID ;
>> from jobact, jobheads ;
>> where jobheads.JobID = jobact.JobID ;
>> AND jobAct.JobID = "RTvo" ;
>> and not EMPTY( JobAct.OurInvID) ;
>> group by OurInvID, LabourID ;
>> into cursor JobsS
>>
>>
>>What exactly IS VFP 9's problem with this (remember I've only been using 9 for 2 months now)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.