funkytunaa
Technical User
I have a sql database that houses appointment data. I'm trying to create a report that will match up "required" appointments with actual appointments.
Currently I've written a query that counts the number of appointments for each date and returns the day name (ie. "Monday", Tuesday etc..tippin you know the rest), the count and the date, I've filtered this to only give me back the next couple of weeks, so I can get the actual number of apointments back, not a problem.
Where my problem is, I have another table that has the days of the week as titles for the field and a serial number that matches each person and in each field I have a number of "required" appointments for that day of the week.
I need to have a report that will have the dates for the next 2 weeks listed and beside that how many appointments are required and then how many appointments there actually are then the difference.
Hopefully I haven't confused anyone.
Cheers!!!!
Currently I've written a query that counts the number of appointments for each date and returns the day name (ie. "Monday", Tuesday etc..tippin you know the rest), the count and the date, I've filtered this to only give me back the next couple of weeks, so I can get the actual number of apointments back, not a problem.
Where my problem is, I have another table that has the days of the week as titles for the field and a serial number that matches each person and in each field I have a number of "required" appointments for that day of the week.
I need to have a report that will have the dates for the next 2 weeks listed and beside that how many appointments are required and then how many appointments there actually are then the difference.
Hopefully I haven't confused anyone.
Cheers!!!!