I have a table called 'Year' in which I have a field called the 'WeekNo'.I append the records into this table every week & flood the weekno field with a number for that particular weekno(which are in sequence week after week).Actually,the append is to be done automatically with the help of a macro which would run the append Query everytime I open the Database.
ex.if I open the database this week,I would flood the 'WeekNo' field with No=1.next week when I open the database & append the new records,I would flood the 'WeekNo' field with No=2 for those new records...so on & so forth..
For instance,the append operation for the records is done every Monday.
My question is if I open the database more than once anyday in middle of a week,...I need a check that would tell me that the records for that particular week have already been appended..
How would a go about doing it..Do i write a query or a trigger function.?