unique record

[Mr.K]

I have a query which displays two fields: client ID and order type. I want to be able to display the client only once per order type. I tried to use GROUP BY order type but that gives me a missing expression message. I also thought of using UNIQUE as YES in qry properties but I'm not sure as to which row that property applies (all of them?). What is the best way to display a unique client in one row and order type in the other? So for example for order type "CASH" I wil then have a list of unique individualIDs.

thanks,
M

 

[Banana]

One thing needs clarifying- do you want to get lists of unique records for each types, even if the clients may have more than one order types (meaning a same client can appear more than once across each order type)?

 

[Mr.K]

It would be nice to know how to that as well, but in this particular case the choice on the form's combobox specifies the order type to be displayed(querried). Therefore, each time there is only one order type displayed and I need to display indivduals(unique) who used that order type. So:

order_type | individual
cash | individual1
cash | individual6
cash | individual8

but don't want to have repeated:
cash | individual6
somewhere in the list if the individual6 placed the cash order twice.

 

[Mr.K]

I think this solves my post:
In the properties of the query I specified Unique Records to YES. (It is the same as adding DISTINCTROW after the SELECT in the SQL view)