Creating temp table from query results

Before we begin, I can't use SELECT INTO in the SQL query as the temp table I'm trying to create is located in the front end UI accdb, whilst the data tables the query accesses are in the back end data accdb. Let me rephrase that, I don't know how to do this in SQL.

So.....what I'm doing is this:

Please Login or Register  to view this content.

However, the data types being reported are numerical values (eg, 202, 3, 7, etc).

Is there an easier way to do this or am I going to have to write a function to translate these numbers into a proper data type name?


EDIT: Nuts, wrong forum. Could a nice, kind, lovely Mod please move this to the access VBA forum? Ta.