Total Data In Fields

[Cori]

Good Afternoon All,
I have a table devoted to time spent on certain projects. I am trying to make a query to show the total time spent on each project (the data is not in time format) and then turn that into a percent for a report. I have tried doing a summary query, but that isn't giving me the data i am looking for...is there an easier way

 

[pbaldy]

If the data is not in date/time format (why not?), what format is it in?

 

[mhartman]

Hello:

Are you trying to sum the whole column?

More information is needed.

Regards
Mark

 

[Cori]

The data is just numbers and the fileds are number fields (ex. 5 = 5 hours ) so really i just need the total of the numbers entered in those fields.

 

[Cori]

Yes I would like each individal column to have a total.

 

[Brianwarnock]

i would have thought that a Totals query grouping on project and summing the "time" field would have worked.

Brian

 

[Cori]

I am not sure what totals query is, but i don't have any time fileds they are all number fields and i just want the total of all of the numbers in that(those) field(s).

 

[Brianwarnock]

but i don't have any time fileds they are all number fields and i just want the total of all of the numbers in that(those) field(s).

That's why I put time in " "

Brian

 

[Cori]

Sorry, it is time spent on projects, but really they are just numbers. I really should have never said time because i think that is making it confusing...Sorry.

 

[pbaldy]

As Brian mentioned, his suggestion will work on a number field.

 

[Cori]

Each project or catagory is a separte field...i don't have a specific to group by...does that mean there is something wrong with the table since it doesn't give me the data i need???

 

[pbaldy]

Possibly, but without seeing the actual table structure, I doubt anyone here can say for sure. Generally, projects would be records not fields. It sounds like you have a normalization problem.

 

[Moniker]

Are you sure you can't just use an aggregate query and set all of the "Totals" to "Sum" instead of "Group By"? (You turn on the aggregate query by pressing the Sigma in the query design toolbar.)

~Moniker

 

[Cori]

Yes that does work...I figured out why i wasn't getting the info that i needed. Thanks so much for your help