Recent content by execution

In my database i have fields with dates in this format ( 09.09.09). the field is set to text because I imported the data from excel sheets. I really need to convert these values to a proper date format since I have to sort my entries by date. Any help would be much appreciated. Thanks

thank you for your input. im just starting to do access and im not at all familiar with what to do.

hi, I have 8 tables with different information for the same ID. I would like to know how to create a search in a form so that when I type in that particular ID it will derive information from all the tables and list in text boxes in the form that i have created. Any help would be much...