Booleen Test (True or False) Statement comparing cells below

[nguyenak]

Hello,
I dont know how to accomplish the following in Microsoft Access.

Here is the current Table Customer	Type	ProductName	SKU
Jim	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?

[June7]

One way might be with subquery.
Review http://allenbrowne.com/subquery-01.html
Look at the examples for Aggregation: Counts and Totals, Get the value in another record

Another could be with DCount. Is the SKU field a text or number type? Create field in query with expression like:
IIf(DCount("SKU","tablename","SKU=" & [SKU] & "ProductName<>'" & [ProductName] & "'")>0,"T","F")
This should return T for both 1007005 records.

[nguyenak]

Works Great!...thanks June