Hi Terry,
from a first view:
place where after the last on statement, I will see if I understand the other part.
Agnes
>I'm trying to achieve the report below:
>
>
> Derek Bob Angus ...
>Inv. No. Booked Charged Booked Charged Booked Charged
>_____ ______ _______ ______ _______ ______ _______
>1 0.75 0.75
>2 6 5.5 12 11
>3 20.5 20.5
>...
>
>
>So I need to sum the hours worked on a job, under each invoice ID, for each employee (JobAct.Hours), versus the hours required for each (JobHeads.Quantity)
>
>First I'm getting "command contains unrecognised phrase/keyword" and I can't figure what's up.
>
>Here's my pathetic attempt at the SQL. I've come to realise that I could really do with a course on this. I can't tell how successful it is as it won't work but I'm sure it's no good.
>
>
>Select JobAct.OurInvID, JobHeads.JobID, JobHeads.LabourID, ;
> SUM( jobheads.Quantity) as Booked, SUM( jobact.hours) as Charged, ;
> Labour.Text ;
> from jobheads ;
> Where jobheads.JobID = "RTvo" ;
> and not EMPTY( JobAct.OurInvID) ;
> INNER JOIN JobAct ;
> ON jobheads.JobID = jobact.JobID ;
> INNER JOIN Labour ;
> ON Jobheads.LabourID = Labour.ID ;
> group by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ,Labour.Text ;
> order by JobAct.OurInvID, jobheads.JobID, JobHeads.LabourID ;
> into cursor JobsS
>
>
>A help would be much appreciated.
>
>Terry
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]