I need to generate a report with a column of start dates and another column for the end dates. All I have from the database is a list of dates that an employee was absence from work for the past year and what they want is like a frequency list like this:
Start Dates End Dates
2/15/1999 2/17/1999 24 hours
3/22/1999 3/22/1999 8 hours
6/15/1999 6/19/1999 40 hours
When I query the database I just get:
2/15/1999
2/16/1999
2/17/1999
3/22/1999
6/15/1999
6/16/1999
6/17/1999
6/18/1999
6/19/1999
We have not done much with scripts at our company. We are using SQL with an oracle database and are using version 4.1.4. Do you think this can be done with a visual basic script program. Any help would be appreciated.
Paul Richard
Listserv Archives (BOB member since 2002-06-25)