G
GL
Hello
I ‘m trying to work out on the following problem.
I have a data base of tools used for different projects. Some of those tools
are used for more than a project. So when I have a report about the tool cost
of a projects I get the sum of costs for all the tools used. The problem is
I get actually a wrong value if some tools are used also in other products.
What I would like to have is a subtraction from the sum of the tool cost of
what is shared on other projects.
Let’s say when a tool costing 12000 is shared among 3 different projects,
then from each total cost of each project using that tool 8000 should be
subtracted.
My table form is ToolNumber, ProjectNumber, ToolCost, etc (Key on
ToolNumBer+ProjectNumber)
Do you know how a report can do this?
Thank you
GL
I ‘m trying to work out on the following problem.
I have a data base of tools used for different projects. Some of those tools
are used for more than a project. So when I have a report about the tool cost
of a projects I get the sum of costs for all the tools used. The problem is
I get actually a wrong value if some tools are used also in other products.
What I would like to have is a subtraction from the sum of the tool cost of
what is shared on other projects.
Let’s say when a tool costing 12000 is shared among 3 different projects,
then from each total cost of each project using that tool 8000 should be
subtracted.
My table form is ToolNumber, ProjectNumber, ToolCost, etc (Key on
ToolNumBer+ProjectNumber)
Do you know how a report can do this?
Thank you
GL