unique values ??

[hlacroix]

I have a database to track client activity per session.
Each client has a unique client number but multiple activities.
Therefore, if I have 20 clients in the database and each has 3 activities, I have 60 client numbers, 3 *20 = 60. ( Duplicated)
My elementary problem is how do I display the client activity unduplicated so that my query returns only 1 unique client number per session.
I tried the unique records/values in the property box but still.....
Thanks for your help.

 

[ajetrumpet]

Each client has a unique client number but multiple activities.
Therefore, if I have 20 clients in the database and each has 3 activities, I have 60 client numbers, 3 *20 = 60. ( Duplicated)

This is off the topic of your question, but it is very relevant here:

You have stepped out of the realm of normalization. A client does not have a unique client number, because each client has 3 different numbers. A proper set up for this would be a client table and a activities table. One (client) to many (activities) relationship between the two tables.

If you can get this done, a lot of things will flow smoothly. So much so that you might not even notice it!

I'll be the first one to admit that working with the source objects (the tables!) in this program is the biggest pain in the butt out of anything else there is to do, but if you don't start things right in that regard, the future is usually not to bright.