Attendance Count

[dtheweather9]

Currently, i have set up a event database and a member database. This is combined in a event form where the event information can be filled out (event name, data, description, etc... as well as check off the names of members who are in attendance. I have about 5 events with data in them, and I want to do a couple of things. 1st, i want to have a place on the form where it tallies and gives a total of the members who are in attendance. Second, The list is currently sorted in order of ID key, where I would like to have it made into an alphabetical listing. I'm not sure how exactly how to do this, and i would appreciate the help.
Thanks,
Dan P.

 

[georgedwilkinson]

I'm not sure what you're asking or why you included a large screen print which doesn't seem to have anything to do with what you say you're doing.

To sort data on a form, you can do it basically 3 (easy) ways (there are more difficult ways, too).
1. Modify the recordsource of the form in the QBE and click "Ascending" in the sort order for the column in question.
2. Set the sort order in the form's "Order By" property.
3. During run time, right click on the field you want to sort on and select the desired sort order.
4. (bonus) During run time, select the field, and on the "Home" ribbon thingy, select one of the sort icons in the sort & filter subsection.

I believe the answer to the other question that you didn't ask is: you'll need to create a junction table between your 2 tables. Then you'll need to create a subform based on the junction table. See Pat Hartman's M:M sample: Many-to-many example