Dsum (I think)

M

Marc S

I have a table (tasktable) of timesheet entries that includes data for
employee tasks that includes numerous fields including (taskid), (empno),
(jobno), (hours), (charges) . I also and a table (emptable) that includes
data for each employe including (empno) and (empcat) where each employee is
assigned to a category A, B, C, or D.

I need to generate a query that provides sums of hours and charges for all
employs by category that would look like:

JobNo HrsCatA $CatA HrsCatB $CatB ........

Should I use DSum to get these results? If so, what would the expression
look like?

Thanks,

Marc
 
D

Duane Hookom

You would probably want to create a crosstab query. Do an advanced search of
Google Groups on "multi-value crosstab group:*access.Queries*
author:hookom"
 
Top