summary table report generation

[randy remark]

Hi I am struggling to get my head around this problem, let me first explain

I have 2 databases

1 is a database of activities (ie Football,Swimming etc)

and I have another database called bookings

in the booking database I have the following fields (just the relevant ones shown)

Name

MondayMorning

MondayAfternoon

TuesdayMorning

TuesdayAfternoon

(basically 2 fields for everyday of the week, morning and afternoon.)

The fields are ComboBoxes showing a valuelist of all the available activities from the activity field in the activity database)

I need to be able to produce a report showing in popularity order the activities, something like this

Football 1987

Swimming 1400

Cycling 1008

..

Walking 12

I assumed that this would be easy when i started this project but I am having trouble getting my head around it.

Any help would be hugely appreciated.

Cheers

mark

[danjacoby]

Mark, for shame!

THIS IS A DUPLICATE POST!!!