gsrai31
01-10-2008, 03:16 AM
I need some help I suppose is meant to be a self join query -
I have a table called tblExport with 4 fields – ID, Date, Destination and Status. I want to be able select records where Date is same, Destination is same and the Status is Success for some IDs and Transport for some others. So I can only see if on the same day to the same destination, status of one or more records was showing “Success” and one or more were showing “Transport”. I have attached an example spreadsheet with some records so that it makes more sense. Hope someone can help me with this.
Many thanks.
gsrai31
I have a table called tblExport with 4 fields – ID, Date, Destination and Status. I want to be able select records where Date is same, Destination is same and the Status is Success for some IDs and Transport for some others. So I can only see if on the same day to the same destination, status of one or more records was showing “Success” and one or more were showing “Transport”. I have attached an example spreadsheet with some records so that it makes more sense. Hope someone can help me with this.
Many thanks.
gsrai31