How to update field 1, 2 or 3, when they are null but leave as it is if they have information?

[Fernando Access]

Hello everyone,

I'm trying to do an update query where I have, Field 1, Field 2, Field 3 and Field 4 if type says BTO as restriction.

However, I only want Field 1, 2, 3 and 4 to be updated if any of them are blank, but if any of them has information, I don't want that to be updated and want to keep the original data.

Is it possible to make it in a single query?

Current query in image.





Thank you in advance!

[orange]

Instead of showing us something from an Access screen, why not tell us
- an overview of the "business"
-what you are trying to do in plain English
- sounds like a logic/flow chart

if x and y and z then
 do something1
else if XXX then
  do something2 
....
else
 don't change anything
end

[JamesDeckert]

>>I only want Field 1, 2, 3 and 4 to be updated if any of them are blank, but if any of them has information, I don't want that to be updated
Wouldn't it be more accurate to say "I only want Field 1, 2, 3 and 4 to be updated if ALL of them are blank"
If this is the case you want the "is null" for all 4 fields to be on the same row as the BTO

Actually upon rereading your post again, I can't tell if you want no field updated if any of the 4 fields has info (see above), or if you don't want an individual field updated unless it is empty.

[Fernando Access]

Its component information for computers.

My line record would look as the following:
SKU: ABCDEFG#RRM, PROCESSOR_CHILD_PART_NUM: (blank), Processor Description: Intel i3 400GHZ, Processor Type: (blank), Processor Summary: Intel i3

So what I want to tell the query is: if my Part# from tbl_File is equal to my Part# in tbl_Processor, update me only the labels that are null and leave alone the cells that already have information as they are, do this only when my SKU Type says BTO.

[Fernando Access]

Hi James: thanks for the reply,

What I want is to update fields that are blank but if they have information I want them to leave it as it is, and only do this is my Part# of tbl_File is equal to Part# of tbl_Processor, where my SKU is "BTO".

If my record is the following:
SKU: ABCDEF#RRM, PROCESSOR_CHILD_PART_NUM: (blank), Processor Description: (blank), Processor Type: AMD, Processor Summary: AMD A-Series, SKU_Type: BTO
Result: ABCDEF#RRM, PROCESSOR_CHILD_PART_NUM: HIJKLMOP#RMA, Processor Description: AMD A8 Quad Core, Processor Type: AMD, Processor Summary: AMD A-Series, SKU_Type: BTO

[June7]

I am not sure which table is the source and which is the destination.

Try this in the UPDATE TO row:

Nz(DestinationTable.PROCESSOR_CHILD_PART_NUM, SourceTable.Processor_Child_Part_Num)

or

IIf(DestinationTable.PROCESSOR_CHILD_PART_NUM Is Null, SourceTable.Processor_Child_Part_Num, DestinationTable.Processor_Child_Part_Num)

[Fernando Access]

I am not sure which table is the source and which is the destination.

Try this in the UPDATE TO row:

Nz(DestinationTable.PROCESSOR_CHILD_PART_NUM, SourceTable.Processor_Child_Part_Num)

or

IIf(DestinationTable.PROCESSOR_CHILD_PART_NUM Is Null, SourceTable.Processor_Child_Part_Num, DestinationTable.Processor_Child_Part_Num)

Thank you for the answer June, this is for PROCESSOR_CHILD_PART_NUM, if I have 2 other labels such as Processor Type and Processor Summary, do I need to create one query for each label or is it possible to do it in a single code? Keeping in mind that I only want those null values to be updated when my SKU_Type is "BTO".

Regards,
Fernando

[June7]

Can update as many fields as you want in a single SQL action.

If you want to restrict records that are impacted by the UPDATE, apply filter criteria to the SKU_Type field.

[Fernando Access]

June, thank you this is exactly what I was looking for.