ok i have two queries pulling information from two tables.

the two queries contain identical fields however query one contains and extra field called Date and is of type Date\Time (short date)

i need to union the two queries into one including the Date field, so i created an extra field in query two and called it Date: "" as so. i did this because the next step requires identical fields.

then i created the union query combining the two queries together. All looks great until i begin looking closer. the date field that is of type Date\time is converted to text during the union because the field Date in query two is text. This is a problem for me as i need to pull information from the unioned query via the date value.

so my question is this, is there any way within query two that i can create a field of type Date\Time (Short Date) ;like i would with text IE "Date: "" "