Creating Summary View
Creating Summary View
I have set up my first creator db to get some experience on it. My background is access so looking for something to easily create 'shareable' databases easily.
My first app is one to track a group of runner's activities. It has two forms now, one to collect participant info (name, group, office) and one for them to log their activities (date, miles, activity type). The calendar view worked great as a vehicle to have them enter their activities.
I am struggling to figure out how to create a summary view of the activity log:
group on user, then show count of dates and sum of miles.
I see group by in the view definition and sum as an option, how do I add count?