G
Gordony
Hi,
I'm new to the Access database query language & need some help regarding
"null values" & converting them into another record within the Access
database. The question & background is:-
I have extracted some payroll data from another database (excel) & have
copied it into an Access table (payroll table). One of the fields in the
table, "Tasks" contains records of payroll tasks & in that field there are a
number of null records. What I want to do is have a new updated "Task" field
within the table which takes all null records & updates them with another
record from another record field within the table & keeping all the remaining
"Tasks" as well. As an example, the table is set out below as a before &
after scenario:
Before:
Field Field
Task Location
Fulfill
Backlist Picking
Returns
Perm Stk Stock
After:
Task Location
Fulfill Fulfill
Backlist Backlist
Returns Returns
Perm Stk Stock
Cheers
Gordon
I'm new to the Access database query language & need some help regarding
"null values" & converting them into another record within the Access
database. The question & background is:-
I have extracted some payroll data from another database (excel) & have
copied it into an Access table (payroll table). One of the fields in the
table, "Tasks" contains records of payroll tasks & in that field there are a
number of null records. What I want to do is have a new updated "Task" field
within the table which takes all null records & updates them with another
record from another record field within the table & keeping all the remaining
"Tasks" as well. As an example, the table is set out below as a before &
after scenario:
Before:
Field Field
Task Location
Fulfill
Backlist Picking
Returns
Perm Stk Stock
After:
Task Location
Fulfill Fulfill
Backlist Backlist
Returns Returns
Perm Stk Stock
Cheers
Gordon