Combining two colums of data into one (if one or the other is Null) 1

[CrystalKim]

Hi all,

I have two fields. One is called Mat Date and the other is Est Mat Date. My problem is that the two fields basically mean the same thing but are in two seperate fields. Whenever there is a date in the Mat Date field than the Est Mat Date field is null and vice versa.

What I need to do is merge the two together to have one field. This is how it looks in my brain.

If Mat Date is null then Est Mat Date

else

Mat Date

I don't know how to code this though and would appreciate some help on this.

Thanks as always.

 

[PHV]

I have two fields
Where ?
A word document ?
An Excel spreadsheet ?
An Access table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CrystalKim]

Doh, sorry. That would help (multi tasking here).

It is in an excel spreadsheet

Thanks

 

[GlennUK]

Are these simply data items that need to be merged? If so, you could copy one over the other and tick the "Skip Blanks" tickbox ( when doing the Paste Special ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[CrystalKim]

Thanks Glenn, I never knew you could do that with Paste Special. Very cool and it worked like a charm.

 

[GlennUK]

My pleasure. :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.