Dont want to show duplicates, and want to show how many clients

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm doing a report of the customers who log on my web site in a day. Some of
the clients log twice or more in a single day. But I dont want to show them
again in the report. How do I remove them of the report or the query?
After that how can I count the number on clients that have log in the day so
I can show it in the report?

Thanks

J-E
 
J-E said:
I'm doing a report of the customers who log on my web site in a day. Some of
the clients log twice or more in a single day. But I dont want to show them
again in the report. How do I remove them of the report or the query?
After that how can I count the number on clients that have log in the day so
I can show it in the report?
Click to expand...


If the data for the report is truely duplicated (in all
fields), then just set the query's Unique Values property to
Yes.

If the data has some fields that are different fo a single
customer, I'll need more details.
 
So here is what I get with the duplicates:

created_date prenom nom entreprise
2004-11-30 10:07:49 Sébastien Gauthier Audio Video Matane
2004-11-30 10:53:36 Sébastien Gauthier Audio Video Matane
2004-11-30 10:47:08 Sébastien Gauthier Audio Video Matane
2004-11-29 15:02:44 elizabeth lafleur caméra expert
2004-11-29 15:14:04 elizabeth lafleur caméra expert
2004-11-29 13:10:44 elizabeth lafleur caméra expert
2004-11-30 14:42:48 Jean Spain Dumoulin La Tuque


And here is what I want:

created_date prenom nom entreprise
2004-11-30 10:07:49 Sébastien Gauthier Audio Video Matane
2004-11-29 13:10:44 elizabeth lafleur caméra expert
2004-11-30 14:42:48 Jean Spain Dumoulin La Tuque

Thanks

J-E
 
J-E said:
So here is what I get with the duplicates:

created_date prenom nom entreprise
2004-11-30 10:07:49 Sébastien Gauthier Audio Video Matane
2004-11-30 10:53:36 Sébastien Gauthier Audio Video Matane
2004-11-30 10:47:08 Sébastien Gauthier Audio Video Matane
2004-11-29 15:02:44 elizabeth lafleur caméra expert
2004-11-29 15:14:04 elizabeth lafleur caméra expert
2004-11-29 13:10:44 elizabeth lafleur caméra expert
2004-11-30 14:42:48 Jean Spain Dumoulin La Tuque


And here is what I want:

created_date prenom nom entreprise
2004-11-30 10:07:49 Sébastien Gauthier Audio Video Matane
2004-11-29 13:10:44 elizabeth lafleur caméra expert
2004-11-30 14:42:48 Jean Spain Dumoulin La Tuque
Click to expand...


Always put together the report's record source query first.
In this case, I believe you want:

SELECT Min(CreatedDate) As Created, prenom, nom, entreprise
FROM thetable
GROUP BY prenom, nom, entreprise
 
Back
Top