Solved Open a filtered query from a Cmd Button

[arnelgp]

see the query in design view (property->Unique Values = Yes)

 

[Gasman]

you are wrong, I always study what you tell me

That is refreshing to know.

 

[asteropi]

see the query in design view (property->Unique Values = Yes)

I saw that and I went into the SQL too and saw you made it distinct. I'm not sure about the language yet but please help me understand

Here:

SELECT DISTINCT ProductDetailsT.ProductDetailID, OrdersT.CustomerID, ProductDetailsT.SKU, ProductDetailsT.ProductName, OrderDetailsT.DiscountPercent
FROM ProductDetailsT INNER JOIN (OrdersT INNER JOIN OrderDetailsT ON OrdersT.OrderID = OrderDetailsT.OrderID) ON ProductDetailsT.ProductDetailID = OrderDetailsT.ProductDetailsID;

You basically told it to select all the unique fields and not just SKU and Discount?

 

[arnelgp]

You basically told it to select all the unique fields and not just SKU and Discount?

yes. in design view:

 

[asteropi]

yes. in design view:
View attachment 116007

yeah I saw that. Thank you