The access application created by me works not properly when used in other computers which have date format in US format. An append query which has date fields insert duplicate records in the destination table. How can we prevent it. Is it possible to ensure the date format in the access application is in UK format dd/mm/yyyy irrespective of the system format . ie. Even if the application is used in a system which has date format in US mm/DD/ yyyyy all the date fields in the application should be UK format of DD/mm/yyyy . Please help.