I have a database that I need to extract records from based on matching values.
Job Task Status
House Framing Complete
House Siding Complete
House Painting Complete
Barn Framing Complete
Barn Siding Incomplete
The result I want from the data above would be to show the record "House" but not the record "Barn". If I could get the result to show only one instance of "House", that would be great, but if the result is that it shows the three records with "House", I'll use Excel to delete duplicates. My goal would be to count the number of unique records.
Thanks in advance.
Mike
Bookmarks