DAP Query Criteria Question

[Jason Lopez]

Below is the defining line in my DAP query that is working for the overall
operation. However, the table it pulls the data from can have all caps, all
lower case or a mix and the query does not recognize the difference.

PriorStat:
IIf(dbo_Workflow.SpecialRouting="Priority","Hot",IIf(dbo_Workflow.StatusNote
Like "Monitor%","Monitor",IIf(dbo_Workflow.StatusNote Like
"Priority%","Hot",0)))

What I am trying to get is where is someone puts "MONITOR - Due 9/27 EOD) in
the dbo_Workflow.StatusNote field of the table, I still want it to be
grabbed. However, my DAP query is only grabbing those that are spelled
"Monitor." Same for the final criteria of the entire line (Priority). Is
there a way that the query will take whatever is in that field (StatusNote)
and then mark it based on what is says and not whether it is upper or lower
case?

Jason Lopez

 

[John Spencer]

You might TRY the following. I'm not sure that UCase will be available to
you in a DAP query.

PriorStat:
IIf(dbo_Workflow.SpecialRouting="Priority","Hot"
, IIf(UCase(dbo_Workflow.StatusNote) Like "MONITOR%","Monitor"
, IIf(dbo_Workflow.StatusNote Like "Priority%","Hot",0)))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..