H
hikaru
I have the following report:
http://img184.imageshack.us/img184/1310/contractsreportskt8.jpg
the blue lines are from a table (from users table)
the red line is from the subtable (from tbl_Contracts)
the grean headings are from the subtable of the red line table (from
Tbl_Cont_Monthly_Change)
what i want to do is to create a count field in the grey lines to count the
number of Contracts for each Engineer. the one that i've created view the
count as (4) when it should be 2 only (2 red lines for the first engineer).
so the 4 it gives me is the count of Tbl_Cont_Monthly_Change records related
to this contract. how can i fix this? [ the Control Source of the Count
field i used is =Count([Contract_No]) ]
i also want to calculate the last approved value of each contract. so here
for the engineer whose ID is 28, it should calculate only 241,000 +
5,777,012. how can I do this?
any help is apprciated, thanks in advance
http://img184.imageshack.us/img184/1310/contractsreportskt8.jpg
the blue lines are from a table (from users table)
the red line is from the subtable (from tbl_Contracts)
the grean headings are from the subtable of the red line table (from
Tbl_Cont_Monthly_Change)
what i want to do is to create a count field in the grey lines to count the
number of Contracts for each Engineer. the one that i've created view the
count as (4) when it should be 2 only (2 red lines for the first engineer).
so the 4 it gives me is the count of Tbl_Cont_Monthly_Change records related
to this contract. how can i fix this? [ the Control Source of the Count
field i used is =Count([Contract_No]) ]
i also want to calculate the last approved value of each contract. so here
for the engineer whose ID is 28, it should calculate only 241,000 +
5,777,012. how can I do this?
any help is apprciated, thanks in advance