In my query I want to find the total number of "occasional" bookings.
There are two types: occasional and regular.
However, when I select the tblBooking and the field it finds the total number of all the bookings, which is 10 (5 reg. and 5 occ.). However, I only want to find the occasional (5) and not regular. The field is a drop-down (lookup wizard) so when I type "occasional" into the criteria it says a data mismatch. I've used the 'Count' function, but it still says data mismatch. So basically, I want to count the number of occasional bookings but it's from a drop-down field. It will find the total number (10) of both types of booking, but I only want to find the occasional. How do I do this?
Also, how would I calculate the percentage? I want to find the percentages of both the occasional (50%) and regular (50%) bookings. I don't mean to waffle on. Thank you for your time.
There are two types: occasional and regular.
However, when I select the tblBooking and the field it finds the total number of all the bookings, which is 10 (5 reg. and 5 occ.). However, I only want to find the occasional (5) and not regular. The field is a drop-down (lookup wizard) so when I type "occasional" into the criteria it says a data mismatch. I've used the 'Count' function, but it still says data mismatch. So basically, I want to count the number of occasional bookings but it's from a drop-down field. It will find the total number (10) of both types of booking, but I only want to find the occasional. How do I do this?
Also, how would I calculate the percentage? I want to find the percentages of both the occasional (50%) and regular (50%) bookings. I don't mean to waffle on. Thank you for your time.
