Access complains there's a syntax error but I've not been able to discover where it might be. I've tried the SELECT with and without parenthesis but didn't seem to fix anything. Any ideas?
Code:DoCmd.RunSQL "CREATE TABLE tblOneLabel AS (SELECT BoxID, AreaName FROM tblBoxLabels WHERE [RecID] = 1);"