Hi All,

I'm trying to work out if this is possible as all my current attempts at this have failed.

I have written a query which shows me how many people have attended a course, one of the columns counts the number of people and returns the count correctly.

Now another one of my fields holds the course duration in days, i.e 1,2,3 etc. What I want to be able to do is create an expression that will multiply the count of people on the course by the duration giving me a total of man days consumed by staff attending the course.

Could anybody point me in the right direction of this expression or if it's possible at all. I can do a count and then multiple it by a number. For example:-

select count(*)* 200 from ps_training will work.

However if i include other fields in the select i receive a message about it being not a single group function.

Thanks in advance.
Steve

you need to use GROUP BY

-----------------------------------------
I cannot be bought.  Find leasing information at http://www.joshaxtell.com/

hi,

Quote:

However if i include other fields in the select i receive a message about it being not a single group function.

 

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

Thanks guys for the prompt response.

Worked a treat.

Steve