Can help me solving this?

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

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.
 
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.
 
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... =(
 
Back
Top