UNHCE Information Technology & Distance Education Blog

Here is a SQL (mini-program you can write) for use with the Blue Ribbon software. It will allow you to cull the database for records of leaders with a certain # of years of service. In this example, we are looking for people with 20 or more years. For that reason, I put in the value of >19. You can adjust it according to your needs.

This one is written to be used with the state database. If you are using it with a county database, then you can skip the "countyID" field in the first line.

Select CountyID, Lastname, Firstname, City,Year4H, Category, Status
From Youth2a.db
Where ((Category = "R") or (Category = "P") or (Category = "G") or
(Category = "A"))
And ((Status = "N") or (Status = "R"))
And Year4H > "19"
Order by CountyID, LastName, Firstname

Note that SQLs can be adjusted, listing field names & values.

For further assistance with this process, please contact MarTech.