summary info problem

[potts]

Hi This is kind've a re-visit to a thread I posted a few weeks back.

I have stored a number of work and rest periods by position for each activity in each session. What I now need to do is summarise the contained information by position for each session. I want the following information in the summary:

Position
TotalWork
TotalRest
Total time (TotalWork + TotalRest)
% Work < 10
% Work Between 30 and 60
% Work > 90

The % calculations are proving difficult. I thought it had been cracked when FoFa posted a response to the thread % Woes. However, I have now found that if I use his method to build sub queries for each of the % calculations, and then bind all the information together in a large query, I get two problems with the answer:

1. I do need to add a method to allow for null values (this is being dealt with elsewhere on the forum - sorta)

2. the %'s are summarised for each value e.g. 7, 8, 9. It's not that I mind this, but when I bind the subqueries, I only get results for the largest value in each. Therefore my calculations are out.

Could someone please try to show me where I'm going wrong. I'm sure that this is not that difficult to do, but I'm having an extremely hard time with it.

Any help is much appreciated

 

[Pat Hartman]

Please don't start a new thread when there are already people helping you with this problem.

 

[potts]

Apologies Pat. However, the old thread went cold about a week ago and I am getting quite desperate to resolve the issue. I'll try to be more patient in future. Sorry.

But, if you do have any suggestions, it would be appreciated.

 

[Pat Hartman]

You can re-activate the thread by posting a new reply to it. That way people can see what has gone before and not waste their time on those things. If you haven't had a response in a week that is more than enough time to wait. Add a link from this thread to the old one.