M
Mo
Hope someone can give me some ideas about this, because I'm completely
stumped.
A user has made a request for a to view of data in the way I've shown below.
The data shows a calender type view of appointments for a visit for a
medical examination. The AppDate is the date on which the person is due to
visit. I know it's a very straightforward matter to list appoinments by the
appointment date.
What the user has requested is a calender type view, where the empty rows
mean there is no-one deu for an appointment for that day (although this
might change!). What I'm having problems with how generate these calender
views for each month a few years into the fiuture and also into the past.
Also, the data below shows only one person per date. I guess if there were
two people with appointments on 6 Jun, then there would be two rows in the
first column for 6 Jun etc.
BTW, at the moment the user prepares his 'schedule' list in an Excel
spreadsheet, with data from the db.
I'm not sure whether this is easily do-able. How do I generate the empty
rows (the data has to held somewhere in the db, right)?
Any ideas would be much appreciated.
AppDate Barcode Surname Forename
Recruited etc etc
01-Jun
02-Jun
03-Jun
04-Jun
05-Jun
06-Jun 1234456669 Smith Laura
09/09/2003 blah
07-Jun
08-Jun
09-Jun
10-Jun 12123456789 Jones Annalisa
05/01/2004 blah
11-Jun
12-Jun
......
31-Jun
stumped.
A user has made a request for a to view of data in the way I've shown below.
The data shows a calender type view of appointments for a visit for a
medical examination. The AppDate is the date on which the person is due to
visit. I know it's a very straightforward matter to list appoinments by the
appointment date.
What the user has requested is a calender type view, where the empty rows
mean there is no-one deu for an appointment for that day (although this
might change!). What I'm having problems with how generate these calender
views for each month a few years into the fiuture and also into the past.
Also, the data below shows only one person per date. I guess if there were
two people with appointments on 6 Jun, then there would be two rows in the
first column for 6 Jun etc.
BTW, at the moment the user prepares his 'schedule' list in an Excel
spreadsheet, with data from the db.
I'm not sure whether this is easily do-able. How do I generate the empty
rows (the data has to held somewhere in the db, right)?
Any ideas would be much appreciated.
AppDate Barcode Surname Forename
Recruited etc etc
01-Jun
02-Jun
03-Jun
04-Jun
05-Jun
06-Jun 1234456669 Smith Laura
09/09/2003 blah
07-Jun
08-Jun
09-Jun
10-Jun 12123456789 Jones Annalisa
05/01/2004 blah
11-Jun
12-Jun
......
31-Jun