Error on multlevel group by not allowed in a SubQuery

S

SRussell

Here is my query:
SELECT Jobs.ROnumber, Jobs.POnumber, Jobs.CustomerID, Jobs.Location,
Jobs.AircraftNo, Jobs.AircraftType, Jobs.CallIn, Jobs.Stop,
Stoppages.StopTimeStart, Stoppages.StopTimeEnd, Jobs.OnHoldTime,
DateDiff("n",[Stoppages.StopTimeStart],[Stoppages.StopTimeEnd])/60 AS
StopNet, (select top 1 WriteUps.JobDescription from WriteUps where
WriteUps.RONumber = Jobs.RONumber order by 1 ) AS JobDescription,
StoppageType.StopType, Jobs.AircraftSeries, Jobs.[Aircraft Location]
FROM ((Jobs LEFT JOIN Stoppages ON Jobs.ROnumber=Stoppages.ROnumber) LEFT
JOIN WriteUps ON Jobs.ROnumber=WriteUps.ROnumber) LEFT JOIN StoppageType ON
Stoppages.StopTypeId=StoppageType.StopTypeId
WHERE (((Jobs.Stop) Between Forms!FrmRptOutofServiceHrs2!StartDate And
Forms!FrmRptOutofServiceHrs2!StopDate) And
((Jobs.CustomerID)=Forms!FrmRptOutofServiceHrs2!CmbCustomerName))
ORDER BY Jobs.CustomerID, Jobs.AircraftType,Jobs.AircraftNo, Jobs.ROnumber,
Stoppages.StopTimeStart
;

My Grouping in the report:
AircraftType, AircraftNo, RONumber.

My detail is the stoppage detail of Type, Start / Stop and Net

Ok, I took out the multiple groups (down to just the RO #) but I get the
same error ??

I have seen others with this problem and a rewrite the query. In my query I
am bringing it some simple text that defines WHAT was the initial call for
this job. As the job continues there are changes to the initial "what" and
flow in a timely fashion in this other table.
 
M

Marshall Barton

SRussell wrote:


I answered this in another newsgroup.

Please don't post the same question multiple times. If you
feel that it's necessary to post to multiple groups, cross
post the question by putting both groups, separated by a
comma, in the one message.
 
J

John Vinson

Ok, I took out the multiple groups (down to just the RO #) but I get the
same error ??

ummm...

What error?

You haven't indicated what the problem is.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top