Make Table Query Parameter Default

[Guest]

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.

 

[Guest]

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

Sheila

 

[Guest]

Thanks Sheila.
Yes I have this set up, but I am sure there is a better way.

 

[adsl]

Thanks Sheila.
Yes I have this set up, but I am sure there is a better way.

 

[adsl]

 

[adsl]

Thanks Sheila.
Yes I have this set up, but I am sure there is a better way.