Search results for query: *

THANKS FOR YOUR PROMPT REPLY! I TRIED THIS: {MP_INPAR6_VIEW.RECV_ALL_G} <> &quot;Y&quot; and {MP_INPAR6_VIEW.INVOLVEMENT_G} = &quot;STN&quot; and {MP_INMAST_VIEW.REPORTED_DATE_G} = {?Date Range} and {MP_INPAR6_VIEW.UCR_TYPE_G} = {?UCR Property Code} (ALSO TRIED IT AT THE BOTTOM) AND IT...

IF ISNULL ({MP_INPAR6_VIEW.RECV_ALL_G})=TRUE THEN &quot;NONE RECOVERED&quot; ELSE IF {MP_INPAR6_VIEW.RECV_ALL_G}=&quot;N&quot; THEN &quot;PART RECOVERED&quot; ELSE IF {MP_INPAR6_VIEW.RECV_ALL_G}= &quot;Y&quot; THEN //PLEASE FINISH THIS FOR ME - I DON'T WANT ANY OF THE Y'S APPEARING ON THE...

I have been following this because I’m having the same problem: I have a date/time field (time is always 12:00:00) that I have converted to Date by using Cdate. My time field is a 4-digit string (i.e. 1234). I want to convert it to a military time field, without seconds, and find out the time...

IT WORKED!!! Thanks so much - it's been driving me crazy for weeks.

{MP_INMAST_VIEW.FINAL_STATUS_G} = &quot;OPEN&quot; and {MP_INPER6_VIEW.INVL_G} = &quot;SUS&quot; and {MP_INMAST_VIEW.NATURE_OF_CALL_G} = &quot;290&quot; OR {MP_INMAST_VIEW.NATURE_OF_CALL2_G} = &quot;290&quot;

Nature of Call #1, Nature of Call #2, and Final Status are all part of a larger table (called InMast) - Involv is part of a larger table (called Pers) and I have linked InMast and Pers by Case Number.

Nope - didn't work

I have two tables that have the same info: {NATURE OF CALL #1} = &quot;290&quot; OR {NATURE OF CALL #2} = &quot;290&quot; The above formula in Select Expert gives me what I want - all cases classified as 290. The problem comes in when I want to apply more filters: and {INVOLV} =...