arvids Posted February 4, 2005 Share Posted February 4, 2005 Is it possible to use a calculation, to return the number of non-identical posts based on one field. To explain what I mean, I have a db with posts relating to clients. Every post have a client number, and in the cases where a client have multiple posts, that client number will be used over and over again. I do need to know how many clients are in the DB, but not how many posts. So let's say this is the db: _________________ Posts Clients 4 North 1 Smith 9 Roberts __________________ Here I want the number 3, to reflect that there are 3 clients. Can I get that? How? Regards arvids I wanted to search for an answer to my question, but could not define a search in a useful way... Link to comment Share on other sites More sharing options...
This topic is 6626 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now