[AccessD] how do i do this?

Hello Group,

I have a table with 5 fields, see below. (Diag3 isn't seen in the table)
I would like to have the records back where in "Diag1" or "Diag2", The value of Rapnaam is (part) present and Where "Diag3" is empty

Thanks

Pedro



RapNaam     Pap   Diag1                                 Diag2

B07-08041   1     B07-08041_13-11-07_uitsl.plav*pap1		
B07-06205   1     B07-06205_07-09-07_uitsl.plav*pap1	B07-07544_07-10-07_geen
B07-07901   1     B07-08990_07-11-07_g.a*g.ec*pap1		
B07-05286   1	  T07-06666_11-07-07_Cervix*geen afw