topic Re: Greater than or blank in App Development

Greater than or blank

lukenathan — Thu, 04 Apr 2019 02:47:23 GMT

[tblResult]:
Load
“Archive No.”,
“Machine No.”,
“Build Begin”,
“Build End”,
“Start to Finish”,

IF((“Start to Finish” > 7)OR Len(“Build End” = 0 ),'N') AS [Certified]

Resident [tblCustomer]:

The LOAD statement above is producing this table…

However, I want it to produce this table. The difference is the 3rd record in the certified field. The record should be ‘blank’ but instead I get ‘N’

Can you help?

jonathandienst — Thu, 04 Apr 2019 04:55:58 GMT

Maybe this (comparisons with null will always return false):

If(Alt(“Start to Finish”, 0) > 7 Or Len(“Build End”) = 0 ,'N') AS [Certified]

Is there condition for which 'Y' should be returned

PV — Thu, 04 Apr 2019 07:04:32 GMT

Here ')' placement has gone wrong
IF((“Start to Finish” > 7)OR Len(“Build End”) = 0 ,'N') AS Certified