Hello, I am new to the forums and generally new to Access as well. I have been creating a database using MySQL and have now imported the data tables into Access. Where I am currently struggling is queries, I have a number of successful queries created but I am wondering how I create a particular query in Access.
I have 5 tables...
Booking - bookingcode, delegatecode, eventcode, bookingfee, bedandbreakfast, bedandbreakfastfee, presenting?
Delegate - delegatecode, delegatename, delegateaddress, delegatephone
Course - coursecode, coursedate, coursetitle, coursefee, courseduration
Venue - venuecode, venueaddress, venuename, venuecost, venuephone
Event - eventcode, venuecode, coursecode, eventname, eventdate, presenter
The query as created in MySQL is as follows,
This basically lists the number of delegates requesting bed and breakfast at each hotel.Code:select venuename, count(bedandbreakfast) as totalbb from venue, booking, event where booking.eventcode = event.eventcode and event.venuecode = venue.venuecode and bedandbreakfast='Yes' group by venuename;
I just don't now know how to create that exact query in Access...?
Thanks for your time.