Access_guy49
Registered User.
- Local time
- Today, 09:48
- Joined
- Sep 7, 2007
- Messages
- 462
OK, currently I have a listbox which displays some results using an SQL query in the row source. In the list box i display records from a parent and child table. Therefor i'm getting duplicate information from the parent. (picture)
This is what i want for display purposes. But I want to be able to create a tally of all the students that came. In the example attached, You can see that for the first record, there are actually 3 parent records displayed each with 80 kids. but truely there was 80 in total... not 240.
I was hoping to run some VB code to tally the results in my list box, but adding the values in the column wont give me the results I want. Any Ideas? should I use a hidden list box with ONLY the parent records?
This is what i want for display purposes. But I want to be able to create a tally of all the students that came. In the example attached, You can see that for the first record, there are actually 3 parent records displayed each with 80 kids. but truely there was 80 in total... not 240.
I was hoping to run some VB code to tally the results in my list box, but adding the values in the column wont give me the results I want. Any Ideas? should I use a hidden list box with ONLY the parent records?