Running Total (Count) on Text Field

  • Thread starter Thread starter Sharon Milton via AccessMonster.com
  • Start date Start date
S

Sharon Milton via AccessMonster.com

Hi there,

I am "trying" to write a DB for an engineering project.

I am currently working on a query that will count all Documents associated
with an activity. The relationships are many to many and i have a table
for Programmes (Ativities) as follows:

Programme Table
Act_No (Text, Primary)
Description
Original_Start
Original_Finish
Original_Duration (not derived from Start and Finish date)

Revision Table (Documents)
Rev_ID (Primary)
Doc_Revision_No
Doc_Acceptance_No (what i need to count)

Rev_Prog (Junction Table)
Rev_ID
Act_No
Actual_Start
Actual_Finish

In require a report that will output the following:

I1. Activity No, Desc, Orig Start, Orig Finish, Orig Duration (From
Programme table)
2. Design Delays (PCC_Date - MLM_Date) - 14 (from Revisions Table)
3. No of Docs = count of Trans_No per activity (Eg how many docs are
associated with that activity - struggling with this bit).
4. Impact Delays Total Delays/No of Docs (from Design Delay and No of Docs).
5. Design Delays = Impact + Original Duration.

Can anyone help me with this query - in basic speak pls as a newby (Ta!)
 
forgot to say that step 2. comes from fields in Revisions Table also.
Have created a query up to point 2. but stuck from there on.
 
Back
Top