Usage Statistics

[aescleahs]

Hi, i need to create a query that calculates the percentage usage of certain
feilds
Im creating a booking management system.
i need to work out the percentage that certain booking slots are used eg
Monday - Morning
Afternoon
Evening
and how many times in a week they have been booked.

Thanks in advance
Aesc-leah

 

[ChrisJ]

Posting the table/field names of your source, and sample data would be a good
start, as would a sample of the output you want