Calculate payments

[aceavl via AccessMonster.com]

hi!

i have a query that gives me the date of the next pay ment depending on what
type of credit it is on
example:
8 weekly payments from a total of 100= 12.5 every week.
but now i need to know not just when will they pay and how much but how much
do we expect to collect the next month!
i need to put this in a report, how do i get all those payments???

my query after some unions is like this

SELECT UnionAllNEXT.EmpID_PK, UnionAllNEXT.Next, tblEmp.Emp_Mon, tblEmp.
Emp_Per, tblEmp.Emp_Pla, tblEmp.Emp_Can, tblEmp.Emp_Quitar, [Emp_Mon]/
[Emp_Per] AS [A Pagar]
FROM tblEmp INNER JOIN UnionAllNEXT ON tblEmp.EmpID_PK = UnionAllNEXT.
EmpID_PK
WHERE (((tblEmp.Emp_Can)=0) AND ((tblEmp.Emp_Quitar)=0));

hope someone can help me!
thanxs