(OrderId AUTOINCREMENT (1,1) PRIMARY KEY , OrderDate DateTime NOT NULL, , Amount CURRENCY ) Here i have created an order table with query and tested with access 2010 , it works!
Reply from Richard Rost:
Oh, sure. This is definitely possible. In fact, I cover this in part 3 of my SQL SEMINAR. However, I wouldn't say it's a "better" way to create a table. It's a good option if you need to create temporary tables, or want to allow the user to add a table on the fly without having to know anything about Access design. However, for the average Access user I would still recommend sticking with the good-old table designer.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.