I have been looking through the forums for a solution. I have tried various forms of the following:
My problem is that I need to ignore the record if both are "" or both are null or possibly one of each.Code:SELECT WorkOrderNo, QualityNo FROM RCAData1 WHERE NOT WorkOrderNo ="" And QualityNo ="" ORDER BY RCAData1.WorkOrderNo;
The synatx for this has my head pounding. Or maybe it is from banging it on the table.