Query to total several fields

[lpgagirl]

Hello all:

I have a select query:

It contains the following fields:

WorkorderID (Group by)
ManHours1 (Sum)
ManHours2 (Sum)
ManHours3 (Sum)

Currently it returns the sum of labour for three different technicians working on the same workorder. I have an additional field called Total Man hours. I would like total man hours to return the sum of MH1, MH2 and MH3.

Problem: I cannot figure out how? (calculation)

Thanks as usual,



Jeannie

http://thefloyds.50megs.com/index.html

 

[PHV]

TotManHours: Nz(Sum(ManHours1),0) + Nz(Sum(ManHours2),0) + Nz(Sum(ManHours3),0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lpgagirl]

Thanks so much PHV, what would I do with out you?

Jeannie

http://thefloyds.50megs.com/index.html

 

[MichaelRed]

more general advice on the topic is available in these fora. try search for "basRowSum"




MichaelRed