How to change three numeric fields into a date using Access

If your data source is Access, It is easy to take three number fields in a table and make them into a nicely formatted date by using an expression in a query (a saved query can be used as a data source).

Datestr: Format([mm] & "/" & [dd] & "/" & [yy])

Where [mm], [dd] and [yy] can be any numbers that make sense. Here is sample output:

Query1