Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

?Creating NewTable AS OldTable

ToniStorhannusToniStorhannus Member Posts: 6
Hello
So i have this problem while trying to greate a temporary table which is alike to another. Just that i only need to get reguired fields to new table.
The sentence that i have tried and all its modifications was


Create Temporary Table NewTable(Field1, Field2, Field3)
AS (Select OldTable.Field1,OldTable.Field2,OldTable.Field3
FROM OldTable Where OldTable.Field1 like ....);

Access tells that the proplem is the syntax of using Create.

Thank you very much For advance
Toni Storhannus



Comments

  • ToniStorhannusToniStorhannus Member Posts: 6
    I did find a solution to my problem...
    Thank you.

    The propriate code was generated by access it self. I just did not know.

    SELECT Lapsi_taulu.* INTO HaetutTietueet
    FROM Lapsi_taulu
    WHERE Lapsi_taulu.Sukunimi LIKE Aloituslomake.Haku;




  • Justin BibJustin Bib USAMember Posts: 0

    ______ ( http://forcoder.org ) free ebooks and video tutorials about // Visual Basic Objective-C C++ Swift Assembly Ruby Visual Basic .NET Java Delphi R C MATLAB Go JavaScript Perl C# PHP Scratch Python PL/SQL Scheme D Alice Kotlin FoxPro Bash ML Clojure Ada COBOL Prolog Apex VBScript Lisp Hack LabVIEW Scala Awk Dart Lua Julia Erlang F# Crystal Fortran SAS Rust ABAP Transact-SQL Logo // __

Sign In or Register to comment.