Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update fields with blanks
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")); |
#2
|
|||
|
|||
Hi
you may post this in the Access NG :-) -- Regards Frank Kabel Frankfurt, Germany "kash" schrieb im Newsbeitrag ... 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")); |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Links - Problem | Links and Linking in Excel | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Automatic Chart Update? | Charts and Charting in Excel | |||
Formatting date fields after export | Excel Discussion (Misc queries) | |||
pie charts - how to include "zero" fields on Legends | Charts and Charting in Excel |