Hello,
I dont know how to accomplish the following in Microsoft Access.
Here is the current Table
Customer
Type
ProductName
SKUJim Product - Single PS10 1006423 Jim Product - Single CY150 1006430 Jim Product - Single TYS3 1007003 Jim Product - Single ProductA COLOR 1007005 Jim Product - Single ProductA 1007005 Jim Product - Single 250M 1007115
Goal
Customer Type ProductName SKU T/F Jim Product - Single PS10 1006423 F Jim Product - Single CY150 1006430 F Jim Product - Single TYS3 1007003 F Jim Product - Single ProductA COLOR 1007005 F Jim Product - Single ProductA 1007005 T Jim Product - Single 250M 1007115 F
In excel, i create column (T/F) and the logic is d3=d2 (Looking for same sku with different ProductName) and then I drag it down to find my results.
How would I accomplish this in MS Access?