sql sort help required plz

[barnyb3]

i am trying to construct a report and need two of three fields sorted

the fields are project(asc)
risk
hazard(product of two fields in a table called risk)(desc)



sql

SELECT Risk.Description, Project.ProjectName, Project.ProjectID, [Risk]![Likelihood]*[Risk]![Impact] AS Hazards
FROM (Project INNER JOIN Task ON Project.[ProjectID] = Task.[ProjectID]) INNER JOIN Risk ON Task.[TaskID] = Risk.[TaskID]
ORDER BY Project.ProjectName, [Risk]![Likelihood]*[Risk]![Impact] DESC;

 

[boblarson]

ORDER BY Project.ProjectName, Hazards DESC;

 

[barnyb3]

thank you for the reply

I now get a pop up asking for hazards parameter value

barny

 

[barnyb3]

the field hazards is not in a table

i created the field using
Hazards: [Risk]![Likelihood]*[Risk]![Impact]

barny

 

[barnyb3]

Problem sorted thank you for the prompt reply and your time.

 

[boblarson]

Problem sorted thank you for the prompt reply and your time.

If you don't mind, can you post the solution so others can learn from you?

 

[barnyb3]

solution

SELECT Risk.Description, Project.ProjectName, Project.ProjectID, ([Risk]![Likelihood]*[Risk]![Impact]) AS Hazards
FROM (Project INNER JOIN Task ON Project.[ProjectID] = Task.[ProjectID]) INNER JOIN Risk ON Task.[TaskID] = Risk.[TaskID]
ORDER BY Project.ProjectName, ([Risk]![Likelihood]*[Risk]![Impact]) DESC;


I made changes using the grouping function
I deleted then remade the hazards field from the report
The sql seems to have remained the same as it was initially so I am lead to beleive that it was a misconception when using the wizard to set up the report
I am using access2007 and have no real knowledge on the subject.
I have a premonition that i'll probably return to this forum though.
All the best