I am using access2003 for my data base application.I am adding some data to SQL table. After adding the data, the table automatically rearranging the data in alphabetical order . But i want the latest entered data to be on the top of the table not in alphabetical wise. Eg: In field 'name' , i am entering : Ajay, Venkat, Raj etc.. The table will arrange in : ajay, raj, venkat I want the orderin : Raj, venkat, ajay Hope my doubt is clear
A response has been given to your later post. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "jishith" wrote in message news:45A67430-2A4A-4559-A96F-F34A4C608D2F@microsoft.com... >I am using access2003 for my data base application.I am adding some data to > SQL table. After adding the data, the table automatically rearranging the > data in alphabetical order . But i want the latest entered data to be on > the > top of the table not in alphabetical wise. > > Eg: In field 'name' , i am entering : Ajay, Venkat, Raj etc.. > > The table will arrange in : ajay, raj, venkat > > I want the orderin : Raj, venkat, ajay > > Hope my doubt is clear