Newbies simon29 Posted October 24, 2000 Newbies Posted October 24, 2000 I have a database field with a set number of possible values, say 10. I want to be able to count the number of each type of record in that field and display the results of each count. Can anyone help please?
dspires Posted October 24, 2000 Posted October 24, 2000 Create a calculation field for each possibility: possibility_1 for example, if(field="1", "Y", ""). Then create summary fields for each possibility. Summary count in this example or the "Y" could be a number and you could use the summary-total. Not a lean solution, but it works.
Vaughan Posted October 24, 2000 Posted October 24, 2000 Or just create a summary report and print it out.
Recommended Posts
This topic is 9047 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 accountSign in
Already have an account? Sign in here.
Sign In Now