hi thnx all for the help last time.
nw i hav another prob.
i am developing an application for the doctors n wanna store all the patients records.i am using an access database.nw my problem is tat the register no. tat is the identity of the patient has to be calculated by the application itself n it is also the primary key in the table. nw the prob is tat the doctor wants it new every month like suppose todays first of the month n the reg. no of the first patient will be 1_7/2009 n the next will be 2_7/2009 n will continnue till the last day of the month bt when the next month comes up it shld again start with 1 i.e 1_8/2009 n so on. plz help