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