Changing field types

[kwooten]

I am needing to link two tables but one field is in a "May 2012" format while the other table is in a "053112" format.. Is there a way beyond creating a formula to change "053112" into "May 2012"??

[June7]

These fields are not both date/time type? If they are not both date/time, a formula will be required in a query to convert value. Then join query to table.

[kwooten]

Thanks.. This morning I created a table to convert the "numbers" to the "May 2012" format i wanted. Worked like a charm.