Morning all,
I was wondering if it is possible to have sumif (or equivalent) in access for report generation.
An example as to what I am trying to do is as follows:
I am tracking investors into projects, investors can invest into multiple projects so there is a many:many relationship so I have included an investor project table to provide 1:many links. I am currently generating a report which has each single investment made which also includes the project name and who is investing, this works all ok. I would like each row to include the sum of the amount invested in the project (as below). And following that, a percentage calculation to show the proportion that they invested in the respective project.
Investor Project Investing Amount *Total Project Investment* *% Hold* A Alpha 25 130 19% B Alpha 65 130 50% B Beta 20 60 33% C Beta 40 60 67% E Alpha 10 130 8% F Alpha 30 130 23%
Is this possible, your help is most appreciated.
Cheers,
Hammyish