Leslie,
That's correct.
But also......If there is not any impairment such as the case with ID#489A it should be produce as written.
Output Now:
(ex) ID# Impaired Metric Imp. Metric Metric Name
------------------------------------------------------------
489...
Thr data comes directly from a table produced by another program.
The query was produced in order to break the various fields down to determine the cause of the repetitive output.
We were able to determine the cause of the repetition, the (Impaied -- "IM" & " ") field.
When the field is...
Within a large database we inherited there is a problem of repetitive output of certain records.
In the query below for example (ID# 489),
when records for the (Metrics) CHLA or HISTC are produced,
and if the (Impaired) field lists " " the record will
print one line as seen in the 2nd row of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.