I need to Increment a count based on the test date (CLTESTDATE) for each Test Type Code (CLTESTTYPECD) with the oldest date being 1, the next oldest 2 and so on. The count for each person tested should never exceed 6 or 7, also the count needs to populate to a new field in the query. I will...
I am running a query against my data and want to drop all records that are associated with an outcome of 413 (see example below)
Client Title Outcomes
Joe Smith 1B 413, 315, 412
Jane Jones 1B 315, 412
In the example above, I would not want Joe Smith to...
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.