Yes but still having the same problem... because since the
hours are recorded per activity then if an activity
belongs to more than one packet when doing the query I
will have the record duplicated (and the number of hours
of course) for every packet where the Activity appears.
So if there are 3 hours of CAD ADmnistration which is an
activity of Packet 1 and 2, the query will output
CAD ADministration Packet1 3 hours
CAD Administration Packet2 3 hours
Where only 3 hours were spent in CAD not 6!! and maybe
from this 3 hours to were for Packet1 and 1 for Packet2.
I'm really stock on this issue... =(
>-----Originalnachricht-----
>Can't say I'm an expert with any of this, but it looks
like you could
>use a crosstab query to break down the info you need and
then run sums
>from there.
>
>for example: your crosstab would look like this
>
> Total ActA ActB ActC ActD
>Packet 1 8 3 2 2 1
>Packet 2 12 1 4 3 4
>Packet 3 16 6 2 5 3
>
>Hope that's as clear as mud.
>
>"gr" <(E-Mail Removed)> wrote in
message news:<b1a701c4077e$a53dc8e0$(E-Mail Removed)>...
>> Hi, I already have a Time Recording Database. Now
somehow
>> I have to get an estimated time for "Packets" where a
>> packet is a group of activities.
>>
>> In the TR I have a table keeping the activity
description,
>> the hours, name and date.
>>
>> The problem is the following. Let's say I have Packet1,
>> Packet2 and Packet3. The activities for each Packet
could
>> look as follows:
>>
>> Packet1 Packet2 Packet3
>> ActA ActB ActA
>> ActC ActD ActB
>> ActD ActE
ActC
>> ActF ActG
>>
>> Using a field,something like ActPacket I could know
that
>> ActA belongs to Packet1 and 3, ActB To 2 and 3 and so
on.
>> Using the date I could totalize the sum of hours for an
>> activity in a timpe period. For example ActA 5hours in
>> March. But since ActA belongs to Packet1 and 3, how to
>> know from this 5 hours how many were spent in Packet 1
and
>> how many in Packet 3??
>>
>> I hope I'm being clear enough.
>> Any help will be greatly appreciated.
>.
>
|
Similar Threads
