Make Table Query & Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a make table query and I want the SignDate field and a SchoolYr field
to have default values of DATE() and "2006-07" after the table is populated.
How do I do that?
 
Donna said:
I have a make table query and I want the SignDate field and a
SchoolYr field to have default values of DATE() and "2006-07" after
the table is populated. How do I do that?
Click to expand...

Don't use a make table query. Create the table you want and then use a
delete query to clear it and an append query to populate it. That way you
have comnplete control over the structure of the table. You have virtually
no control of that with a make table query.
 
My problem is that I've "inherited" a disaster design of a database. The new
table is populated based on what is put in the original table. I don't have
time to normalize the thing right now so I need a quick fix. What is entered
in that original table changes frequently, so the new table needs to be
updated based on what is in the original table. So I created a macro that
deletes the content of the new table then repopulates it with the most recent
data in the original table, plus it creates other fields that I need & hence
the need for default values for those fields.
 
Okay, I figured out what you were talking about. Now I have a question
regarding how to make a yes/no field have a default value of NULL. Can it do
that?
 
Donna said:
Okay, I figured out what you were talking about. Now I have a
question regarding how to make a yes/no field have a default value of
NULL. Can it do that?
Click to expand...

No, use an Integer instead if you need to support Nulls.
 
Back
Top