Query

[jalenben1]

In Access I have a query where I have a report giving me the following:

Priority MTTR Response Time KPI(Met/Missed)
Major 0:07
Minor 0:42
Minor 0:45
Major 0:22
Major 0:16
Major 0:12
Major 0:12
Major 9:37

I am trying to compute in a query whether a KPI was met or missed. How would I do that in a query. Keep in mind that Priority and MTTR Response Time are field names in a table that I used in a query.

 

[dhookom]

You can't without some table that identifies the Priority and KPI.

Duane
Hook'D on Access
MS Access MVP