I create a MS access database with two table
Main_table : ID_number, Student_name, Class
Collection_Tabl e : Collection_Date , ID_number,
Student_name, Class, PaidForMonth,In stallment, PaidAmount.
Collection_Tabl e relation with main_table.
ID_number, Student_name, Class
PaidForMonth = is a list of month a year.(July to June)
(can choice multiple value in a column)
I use a count(PaidForMo nth) formula in data entry form which is count only collection_date Example: Collection date: 08/08/2015 "PaidForMon th": Jul, Aug,. in the column "Installmen t" it show : 2
but but in the next collection date in the "Installmen t" column shows with previous count 2 + 2 (today's value Sept, Oct). But I want to count today's "PaidForMon th" values 2.
I think everyone can understand my problem. Please solve my problem.
Main_table : ID_number, Student_name, Class
Collection_Tabl e : Collection_Date , ID_number,
Student_name, Class, PaidForMonth,In stallment, PaidAmount.
Collection_Tabl e relation with main_table.
ID_number, Student_name, Class
PaidForMonth = is a list of month a year.(July to June)
(can choice multiple value in a column)
I use a count(PaidForMo nth) formula in data entry form which is count only collection_date Example: Collection date: 08/08/2015 "PaidForMon th": Jul, Aug,. in the column "Installmen t" it show : 2
but but in the next collection date in the "Installmen t" column shows with previous count 2 + 2 (today's value Sept, Oct). But I want to count today's "PaidForMon th" values 2.
I think everyone can understand my problem. Please solve my problem.
Comment