Help with a totals filter

[deiniolj]

I have a table with 4 time fields. from these 4 fields I get totals. What I want to do is breakup the totals depending on which department did the work. So Basically I will have fours total fields.



time1 / Dept /
60 ---/ A
time2 / Dept /
30 -- / B
time3 / Dept /
20 ---/ A
time4 / Dept /
45 ---/ C

Total A | Total B | Total C | Total D
80 -----| 30 ----| 45 -----| 0

What would be the best way round this.

[SoftwareMatters]

Create a query and add your fields. Switch on grouping and select sum in the totals field for time.

[deiniolj]

I'm a little confused. Not used this feature before. (Also using 2010 if that makes a difference)

My table consists of
ID
Details1 = Set question
Time1 = 34
Depatment1 = ETS
Details2 = set Question
Time2 = 20
Depatment2 = AB
Details3 = Set Question
Time3 = 15
Depatment3 = DU
Details4 = Set Question
Time4 = 34
Depatment4 = ETS
totaltimeETS=68 (Want the total time "ETS" spent on this job)
totaltimeDU=15 ("DU")
totaltimeSS=0 ("SS")
totaltimeAB=20 ("AB")

If played around with the calculated filed in the table view, but only get the sum of all 4 fields I need them broken down.

[deiniolj]

Has anybody got any idea with this, the reply I got before doesn't do anything..

[SoftwareMatters]

I think I may be a little confused by your fields. Can you confirm what fields you have in your table.
Thanks.

[deiniolj]

I have a label boxs with the set questions i.e how much time did you spent creating a report.
then a date field (not important)
Time field (set to number)
Dept (with a dropdown with four different departments) Want to be able to figure out how much time each departments spent on each record (for me this would be a person).

So on the
10/03/11 / 25 (mins) / ETS (dept)
11/03/11 / 45 (mins) / AC (dept)

This make better sense.

If you want I can make a smaller version and make a sample..

[deiniolj]

If you have better idea's for me to lay this out it would be appreciated.

Deiniol

[SoftwareMatters]

Sorry still a little unclear. Do you have 4 department and 4 time fields in your table or just 1 of each?

If I were creating this I would have the following:
ID
Question - drop down
Time Spent
Department - drop down

Then to get the totals do the following:
Create a new query.
Add your table.
Add the fields Time Spent and Department.
Switch on grouping and choose Group By on the Department field and Sum on the Time field.

[deiniolj]

I have about 25 questions and 4 departments. It just depends who does the work..

So that 25 time fields that need filling with set dept. From my DB it a initials fields but it the initials correspond to persons in certain dept..

Please look at my sample.

[SoftwareMatters]

Sorry but the computer I am on doesn't have Access10. If you convert it to a 2007 or earlier file format I could take a look for you.

[deiniolj]

It won't let me save as a 2007 file. I will recreate and repost this afternoon. and save as 2007..

[deiniolj]

Try this, and see if it works..