N Number11 Member Local time Today, 04:09 Joined Jan 29, 2020 Messages 624 Mar 14, 2023 #1 Exp1: Val([ORDER_No]) How can i get the wuery to not show #ERROR when using the above for a blank entry please?
Exp1: Val([ORDER_No]) How can i get the wuery to not show #ERROR when using the above for a blank entry please?
N Number11 Member Local time Today, 04:09 Joined Jan 29, 2020 Messages 624 Mar 14, 2023 #2 Its ok found a way Exp1: Val(NZ([ORDER_No],"0"))
