title: Insert multiple records with a date range in MS Access
body: <p>hoping someone can help?  I'm fairly new to Access 2016 and have been tasked with building a very simple booking system for our school's breakfast and after school clubs.
  I have a table with a list of Children (primary key is ChildID), another table (CLUBS) lists the 5 clubs available, and a third table (BOOKINGS) connects the children to the clubs (ChildID, ClubID, DateRequested)</p>
  
  <p>I have a simple form that enables me to select a child's name from a drop down box, then from a list choose a club, then enter the date required.  This saves the record to the Bookings table.</p>
  
  <p>This works fine, however to make it easier to use...I've added unbound Start and End Date fields in the form with a view to being able to quickly book a child in over a term..i.e. rather than having to add each day individually, I enter the child's name, choose a club and then enter start and end dates.  Multiple records are created in the booking table with the Child ID, Club ID identical, but the DateRequested field varies.</p>
  
  <p>We do need to store a record in the Bookings table for the child on each date so we can print a register for each day..as well as for invoicing/reporting.</p>
  
  <p>From looking at VBA...I think I need to use the INSERT INTO command?  Is the best way to do it?  Also I need to make sure that dates within the range that are Sat/Sunday are ignored.</p>
  
  <p>I'd really appreciate any guidance on this and pointers to which commands would work best...</p>