i dont know what you try to say, but as far as the function is concern, it already has an append query inside the function, the same append query you have. dont you get it. running the function and your query will only create duplicate records.
here iam telling you the story,
There is table also in the last attached db named Student this table contains student information along with the decided monthly fee field.
On start of new month i.e on 1st of every month i use append query which generates all student detail from table student to table voucher this help us that if someone left school then a field in table student stop that student to show in next month voucher table after append query.
Through this step all students come together with their monthly fee and help me evaluating un-paid student monthly.
you know what only problem i am facing as else everything is excellent done from your side,
the only problem is that i want function to remove data of student in new query those who already have paid for a certain month, how;
Suppose;
GR 1 have paid in advance for Aug 16 and Sept 16 in the month of jul 16 with the fee of july, so when i generate voucher of Aug 16 through append then in new query the already paid month means GR 1 Aug 16 should be avoided in new query or removed as paid already.
This help me evaulation student defaulter list.. please if you do this as i can't process system without append query and you can see this at your trial as well that before hitting append query no data is coming in tbl voucher.
