---- Edited response, to reflect subsequent functionality changes.----------

You can view a chemistry table for each point on the map by clicking the the "Labels" button on the Map Window.  You can then specify the font color to use for exceedances of each guideline.  There is a checkbox "exceedances only" which you can select to only show exceedances of those guidelines. 

------------------- Original Response  - still valid------------------ 

This is easy within ESdat.  Under Water or Soil Chemistry there is a second output called Environmental Standards.  This shows your concentration and guideline levels for each result. 

You filter for results where your concentrations are greater than a particular standard, or greater than all standards.  An example of the filter that shows all exceedances is (and you can copy this into your filter box)

Concentration > Min_Action_Level

You can use the Filter tab to generate this, or for any specific guideline.  You can also include other filters of course, like for a particular compound or monitoring round.

Edited by moderator Friday, October 28, 2011 4:08:22 AM(UTC)  | Reason: Not specified

Hello Cory,

You can use other approaches to show only results that are not exceedances.

One would be a modification of the "Original Response" but change

Concentration > Min_Action_Level  to

Concentration < Min_Action_Level

A further variation on this theme is to show only detects or only non-detects.  Filtering for the Prefix value; ie Prefix = '<' (for non-detects) or Prefix Is Null (for detects) will provide this.

Alex

Hello Cory,

See Post #2 is this thread.

Alex