+ Reply to Thread
Results 1 to 1 of 1

Creating temp table from query results

  1. #1
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    517

    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.
    Last edited by BellyGas; 03-14-2019 at 12:51 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1