Using Queries to sum times of similar types together

[radguy]

I am having trouble summing times with similar types.



As you can see from this pic, I have the same type of tool but different ID Numbers. Is there a way to sum the total hours waiting for each ToolType and not Tool ID Number? As you can see when I try to sum the total hours waiting, I get the error message 'data type mismatch in criteria expression.'

[ranman256]

remove [Tool ID Number] from the query.
If you still get the error, then you have strings in the sum hrs calc. (hence Data type mismatch)

Try sum(Nz([hrs]) ) to ignore nulls.