Update fields with blanks

K

kash

Below is the code I am working with in Access. Basically, I am appending
fields from one table to another. Once I run this, the field “Change†comes
up with some values. I want to, somehow, make the values of the field
“Change†blank. How can I code it in my statement below?

INSERT INTO Quarter3_Table

( ID, Change, [Last Name], Name, Office, Sex, [Officer Title], [HR
Department], [Asset Class], Style, Product, [HR Functional Title], Function,
[Research(F_OR_Q)], [2nd Func/Dept], [Date Joined Delaware], [Date Joined
Industry], [Date Left Delaware], MBA, School, [Year Graduated], [Other
Graduate Degree], Other_School, Other_Grad_Year, CFA, [Year], [Other Prof
Designation], Bachelors, [BA, BS, Other], Bachelors_School,
Bachelors_Grad_Year )

SELECT

Quarter2_Table.ID, Quarter2_Table.Change, Quarter2_Table.[Last Name],
Quarter2_Table.Name, Quarter2_Table.Office, Quarter2_Table.Sex,
Quarter2_Table.[Officer Title], Quarter2_Table.[HR Department],
Quarter2_Table.[Asset Class], Quarter2_Table.Style, Quarter2_Table.Product,
Quarter2_Table.[HR Functional Title], Quarter2_Table.Function,
Quarter2_Table.[Research (F_OR_Q)], Quarter2_Table.[2nd Func/Dept],
Quarter2_Table.[Date Joined Delaware], Quarter2_Table.[Date Joined Industry],
Quarter2_Table.[Date Left Delaware], Quarter2_Table.MBA,
Quarter2_Table.School, Quarter2_Table.[Year Graduated], Quarter2_Table.[Other
Graduate Degree], Quarter2_Table.Other_School,
Quarter2_Table.Other_Grad_Year, Quarter2_Table.CFA, Quarter2_Table.Year,
Quarter2_Table.[Other Prof Designation], Quarter2_Table.Bachelors,
Quarter2_Table.[BA, BS, Other], Quarter2_Table.Bachelors_School,
Quarter2_Table.Bachelors_Grad_Year

FROM Quarter2_Table

WHERE (((Quarter2_Table.Change) Is Null Or (Quarter2_Table.Change)<>"term"));
 
F

Frank Kabel

Hi
you may post this in the Access NG :)

--
Regards
Frank Kabel
Frankfurt, Germany

kash said:
Below is the code I am working with in Access. Basically, I am appending
fields from one table to another. Once I run this, the field “Change†comes
up with some values. I want to, somehow, make the values of the field
“Change†blank. How can I code it in my statement below?

INSERT INTO Quarter3_Table

( ID, Change, [Last Name], Name, Office, Sex, [Officer Title], [HR
Department], [Asset Class], Style, Product, [HR Functional Title], Function,
[Research(F_OR_Q)], [2nd Func/Dept], [Date Joined Delaware], [Date Joined
Industry], [Date Left Delaware], MBA, School, [Year Graduated], [Other
Graduate Degree], Other_School, Other_Grad_Year, CFA, [Year], [Other Prof
Designation], Bachelors, [BA, BS, Other], Bachelors_School,
Bachelors_Grad_Year )

SELECT

Quarter2_Table.ID, Quarter2_Table.Change, Quarter2_Table.[Last Name],
Quarter2_Table.Name, Quarter2_Table.Office, Quarter2_Table.Sex,
Quarter2_Table.[Officer Title], Quarter2_Table.[HR Department],
Quarter2_Table.[Asset Class], Quarter2_Table.Style, Quarter2_Table.Product,
Quarter2_Table.[HR Functional Title], Quarter2_Table.Function,
Quarter2_Table.[Research (F_OR_Q)], Quarter2_Table.[2nd Func/Dept],
Quarter2_Table.[Date Joined Delaware], Quarter2_Table.[Date Joined Industry],
Quarter2_Table.[Date Left Delaware], Quarter2_Table.MBA,
Quarter2_Table.School, Quarter2_Table.[Year Graduated], Quarter2_Table.[Other
Graduate Degree], Quarter2_Table.Other_School,
Quarter2_Table.Other_Grad_Year, Quarter2_Table.CFA, Quarter2_Table.Year,
Quarter2_Table.[Other Prof Designation], Quarter2_Table.Bachelors,
Quarter2_Table.[BA, BS, Other], Quarter2_Table.Bachelors_School,
Quarter2_Table.Bachelors_Grad_Year

FROM Quarter2_Table

WHERE (((Quarter2_Table.Change) Is Null Or
Click to expand...
 
Top