Newbies Benjamin Foster Posted January 9, 2002 Newbies Posted January 9, 2002 I have a data base which contains names and a number for each name. How do I total a names numbers? in otherwords if I have a feild name which contains "Dan" and a number feild with a 15 and another feild "stan" and a number feild with a 10. then a thrid feild with "Dan" again but this time a 5 I want to add a feild which will disply a 20 in both of Dan's records and a 10 in stans record. I sure this is simple but I can't seem to make it work. I need to have all the data in this data base desplyed at once, I need to see all the records together
tlsparker Posted January 9, 2002 Posted January 9, 2002 One way is to create a summary field defined as Total of your number field. Place it in a subsummary part on a layout (sorted by name field). Then sort your data by the name field and view the layout in preview mode. Hope this helps. Tom
Recommended Posts
This topic is 8425 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