Generate report employees/agent wise

Question

Dear sir/mam in the microsoft access I have main table as a user in that table have field such as name, father name, surname, instalment. And i have second table such that name is agent in the agent table i have data about agent such as name. That both are relational data. Its men when i enter data using form and select particular agent the user will also show in agent subtable. now i want to generate report of particular 1 agent that show users under that agent. In the report i want to see total users, her name, surname, village and total instalment. now second condition is i want the data by selecting agent by combo box. i want to see how many people join between two particular date (filter start date to end date) with particular agent