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)
--sb--