Expression Multiplying Hours by a Number

[71605]

I am trying to come up with an expression that comes up with total man hours.
I have a query that calculates the total number of time spent. I am now
having problems with multiplying it by the number of employees who went. I
have a ReportLog table and a table Agent/Report. Everything is linked by the
report number. So in my agent/report table looks like:

Report # Agent
09-001 1
09-002 1
09-002 2
09-003 4

So I need to somehow multiply by the number of agents who went out.

Can anyone help me out with this?

Thanks in advance!
Amanda

 

[KARL DEWEY]

Design view --
total man hours: [Agent] * [time spent]

OR for SQL --
[Agent] * [time spent] AS [total man hours]