Good or Check formula in Query

[iraidotel@yahoo.com]

Dear All experts Access

With regard,
I have access 2003 and has composed several fields table, on the field there depth_from and depth_to always sequential, if correct his order was given good marks,
and if wrong check mark.
like where the table I want to create a query with the formula
please think its anyone can help for this problem

My best regards,

Ira idotel

 

[CJ_London]

try something like

 SELECT *, iif(exists(SELECT * FROM sheet1 as t where depth_from=sheet1.depth_to and hole_id=sheet1.hole_id),"Good","Check") As CheckEntry
 From sheet1

or

 SELECT *, iif((SELECT min(depth_from) FROM sheet1 as t where depth_from>=sheet1.depth_to and hole_id=sheet1.hole_id)=depth_to,"Good","Check") As CheckEntry
 From sheet1

 

[iraidotel@yahoo.com]

Dear CJ London

thanks to its code,
whether Mr. CJ London, made his example in ms access, because I have not so often used in the access code

thank you


My best regards,

Ira idotel