Make Table Query Parameter Default

A

AH

How do I enter a default parameter to populate a column in a Make Table Query?

Column headers: A B C D

A B & C are polulated with data from another table and D is to be populated
with a defalt parameter. I define D as a parameter in the query, but when I
run the query, it asks for a Parameter Value. I have tried to assign it a
value using Expresssion Builder but have not been successfull.
 
S

Sheila D

You could run an update query afterwards to populate field D - hope this helps

Sheila
 
Top