Adding values in the same field given certain values in other fields

[ElJefe]

I want to add the values of one field for two different values in another field and come up with a sum total of many entires. For example; One field contains a specific type of work ranging from typing to landscaping to flying and others. Another field contains the hours worked in each specific type and yet a third field specifies the gender of the person working. Is it posible to generate a report that will show you how many hours are worked by women flying and typing? If so how do I implement this into my report such that it will show totals for a variety of other fields with duplicate entires. thanks much!

[MMcCarthy]

SELECT gender, typeOfWork, sum([hoursWorked]) SumHoursWorked, gender FROM tablename GROUP BY gender, typeOfWork;

I want to add the values of one field for two different values in another field and come up with a sum total of many entires. For example; One field contains a specific type of work ranging from typing to landscaping to flying and others. Another field contains the hours worked in each specific type and yet a third field specifies the gender of the person working. Is it posible to generate a report that will show you how many hours are worked by women flying and typing? If so how do I implement this into my report such that it will show totals for a variety of other fields with duplicate entires. thanks much!

[ElJefe]

SELECT gender, typeOfWork, sum([hoursWorked]) SumHoursWorked, gender FROM tablename GROUP BY gender, typeOfWork;

Sorry I am pretty new to access and I don't quite follow what you mean by this. Do I somehow enter all of that into a combo box?

[MMcCarthy]

You don't say what else you want to appear on your report but since you're new to access I would say that you could open a new query in SQL design view and copy and paste this in. Then use this query in your report.

Sorry I am pretty new to access and I don't quite follow what you mean by this. Do I somehow enter all of that into a combo box?