Search results

Pls help.. I have a table and i want to enter a new record but it has not to be repeated by date.. example: record no is 1, and the date is November 15,2007.. i just want to use the record no again next year... how can i possibly do that?