Analytical Database

[Guest]

I have been asked to design a database for storing the analytical results for
groundwater sampling. One of the fileds needs to show a non-detect below a
certain threshold. So basically the information in the record should look
like this: "< 0.05" but there may be other records that contain a whole
number value above the detection threshold. Is there a way to make a column
accept both types of data. So that if I enter "ND" (for non-detectable) it
will display "< 0.05" but if I enter a number above that threshold it will
display?

Does that make any sense?

Thanks in advance.

Larry

 

[Guest]

Store zero for the non-detect.
In your query to extract data for reporting or display use this for the
field --
YourLabel : Iif([YourField] < 0.05, "ND", [YourField])

This way you can have your cake and eat it too.