G
Guest
I have a customer that uses a system that I developed to input appointments
for their clients. This customer wants to be able to view a whole months'
appointments in a format that looks like a calendar. In other words, that
has the squares for Sunday through Saturday for each week in whatever month
that they wanted to look at. In each box, in very small lettering, would be
the customer name and time for each appointment that has been made. The
customer would like to use this to see what days and / or times have no
appointments and market those days / times heavily. The Appointments table
has as a foreign key the CustomerID of the Customer table. The Appointments
table also has the date and time of the appointments in separate fields.
Thank you in advance for your time and your replies.
for their clients. This customer wants to be able to view a whole months'
appointments in a format that looks like a calendar. In other words, that
has the squares for Sunday through Saturday for each week in whatever month
that they wanted to look at. In each box, in very small lettering, would be
the customer name and time for each appointment that has been made. The
customer would like to use this to see what days and / or times have no
appointments and market those days / times heavily. The Appointments table
has as a foreign key the CustomerID of the Customer table. The Appointments
table also has the date and time of the appointments in separate fields.
Thank you in advance for your time and your replies.