There must be someone brighter than me...
I am trying to create a report which shows the full history of the student (as they can study more than 1 module), which includes the prospective number of credits, actual credits awarded to date along with invoicing details.
However sometimes a student may have more than 1 invoice raised per module as they may be funded by their employer.(I need to show all financial records).
However when I ask Access to calculate the total number of prospective credits or credits awarded it is calculating these incorrectly when there is more than 1 finance entry. For example John smith is undertaking a 10 credit module, so when he passes this his both is prospective credits and credits awarded should show 15. However because there are 2 finance entries for John for this module both totals are showing 30.
How can I get access to disregard some credits when there has been more than 1 invoice raised for the module.
Any help would be appreciated.
I am trying to create a report which shows the full history of the student (as they can study more than 1 module), which includes the prospective number of credits, actual credits awarded to date along with invoicing details.
However sometimes a student may have more than 1 invoice raised per module as they may be funded by their employer.(I need to show all financial records).
However when I ask Access to calculate the total number of prospective credits or credits awarded it is calculating these incorrectly when there is more than 1 finance entry. For example John smith is undertaking a 10 credit module, so when he passes this his both is prospective credits and credits awarded should show 15. However because there are 2 finance entries for John for this module both totals are showing 30.
How can I get access to disregard some credits when there has been more than 1 invoice raised for the module.
Any help would be appreciated.