Expression -

[LELOA]

Hi

I have develope a form. which pulls information from multiple tables. What I am trying to do is the following

Field - Scrubbed Part number table Q1_2004
Field - Vendor PN Table Q4_2004

If Scrubbed part number is null then go to Table Q4_2004 and put in Vendor PN else leave it blank.

How can I do that

thanks for any help

Lee

 

[SteveR77]

Lee,


You should be able to do what you desire with an update query that has a condition of IS NULL for the Scrubbed part number.


HTH,

Steve