Hi all,
Let me start off by saying that I am VERY new to MS Access!
The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...
Also, if anyone has any hints on how I would save and mail merge these reports out to our intermediaries, these would be much appreciated!!
I have attached my file if that helps!
THANK YOU IN ADVANCE!
Let me start off by saying that I am VERY new to MS Access!
The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...
Also, if anyone has any hints on how I would save and mail merge these reports out to our intermediaries, these would be much appreciated!!
I have attached my file if that helps!
THANK YOU IN ADVANCE!