Hello,
I am trying to create a query (and Im not super familiar with SQL) to try and take a large set of data and limit the values coming from the table to values that limit an ID column to UNIQUE VALUES ONLY, but select the values to remove based upon date and time.
I have a data set with columns shown as [Work Item Number] [Item Type] [Item Subtypes] [Queue First Status] [Event Date] [Event Type], etc etc.
A work item can be worked multiple times over a couple days, weeks or months, so certain items in the data may change, but not all of them and all I care about is the data from the FIRST review. So I would like to limit my query by saying "Only show unique WorkItems by Work Item number (column 1) and show the First/Earliest row that the workitem was reviewed (column 5 - Event Date)"
I know there is a way to do it, but I cannot figure it out through normal means and as I said, I am not great with SQL or VBA. Thanks in advance for any help!