Make-New Table Query Set Default Values FieldName

R

rebelscum0000

Hi Again,

Is Possible to a Make-New Table Query and set the Default Value to
"something" of each FieldName in One Step?

If yes How?

TIA

Regards
Antonio Macias
 
A

Allen Browne

No.

Create a new table with the fields and their properties set up the way you
want. Then use an Append query to add records to this table, instead of a
Make Table query.

If you need to remove the records again before you use the table again, use
a Delete query to do that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make New Table Query Including Data One Step 1
MAKE A NEW TABLE SQL 3
trim in rowsource with Right(), forcing a String return value with $,Access 2007 4
Update Query 2
Help to Exclude Records SQL 6
Setting Fieldname in query with a combobox 6
How to create a VBA function which can be used within a query 11
Using a value from one table to define which field to use 3

Top