I have an unbound field that I want to count all of the post in the form's record source but only the unique ones since there are duplicates. How do you write this in an expression?
Competent Performer
Windows XP 
Access 2010 64bit
I have an unbound field that I want to count all of the post in the form's record source but only the unique ones since there are duplicates. How do you write this in an expression?
VIP
Windows XP Access 2010 32bit
See if this page helps:
http://allenbrowne.com/ser-66.html
Competent Performer
Windows XP Access 2010 64bit
That didn't seem to help. I did some research and it looks like I need to the a Distinct Count but I guess I'm not understanding the syntax. I put =Count(distinct PostID_Number) in an unbound field but it is not working.
Insert a unique and autoincrementing value from an unbound form
lost - linking date field based on a record with smaller Unique ID
Posting Permissions
Reply With Quote