Microsoft Access is a database application that allows you to create tables and queries for your information. Access comes with several different internal functions. One function is a conversion tool. You can convert several different data types to an alternative. One option is converting text to a date. This is beneficial if you have a text that you want to automatically format and show to users on reports. Your queries can be edited using the designer.
- Skill level:
- Moderately Challenging
Other People Are Reading
Double-click the Microsoft Access file you want to edit. This opens the database along with the file you want to edit.
Click the "Queries" menu item in the opening screen. This opens a list of queries you have programmed into the database.
Right-click the query you want to edit and select "Design View." This opens a window where you can edit the Access query using a wizard.
Find the field you want to convert in the list of column names. In the field name, enclose the field with the "CDate()" function. For instance, if you have a text field named "my_date," enter "cdate([my_date])" into the field. The brackets indicate a column name in Access.
Save the query and close the Design Viewer. This brings you back to the main query menu. Double-click the query name. This runs the query and displays the results.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for