Continuous form to show Unique records

[stewegg]

Is there a way to show unique records in continuous form?

eg. Customers, Products, Orders

Customer A
placed Order #1; Order #2; Order #3
All three orders have one same product (Product x)

The form is to show what Customer A bought in the past using....
Customer A main form (detail about customer A)
with Product continuous subform that shows all products that were bought by customer A.
Currently it's showing Product x three different times.


Is there a way to show Product x just once in the continuous form?


Thank you!

[June7]

Not if you want the records in the subform to be editable. You are describing aggregated data. This is really what reports are for.

[stewegg]

If I don't want to be editable, what's the way to show unique data only?

Thank you

[June7]

Bind the subform to an aggregate (GROUP BY) query. Use the TOTALS button from the Query Design tab. Basic Access functionality.

[stewegg]

Thank you very much for your help. It worked great!

[CJ_London]

Alternatively use

SELECT DISTINCT

[stewegg]

How would I do that?
Could you please provide some detail on it?

Thank you

[CJ_London]

not sure who you are asking but for the distinct option you just add the word DISTINCT after the SELECT in your query in the SQL window. Or in the query design view, select properties and change unique values from no to yes.