Sub Summary report search by unique ID and fields
Hi, I am not sure if this is possible!! Could someone let me know if it is or is not.
I have a table called "Product" when a new record is created a new "ClientID" is created per record.
one of the fields is called "product status". I am trying to produce a sub summary result that shows the unique count where a product status is set to one thing (lets say A) but the client does not have other products (records) set to one of two other statuses (lets say B & C)
I have created now with the forums help the fields to calculate Unique Record count of "ClientID" and that is working perfectly - so thank you again but I can not work out how to get a result of unique "ClientId" where one record is at one status but the other ones are not at two different possible statuses!!!
Is this possible.
Thank you in anticipation of your help