how to add the hrs at the end of each month? [message #86411] |
Tue, 28 September 2004 05:11 |
eboy
Messages: 17 Registered: August 2004
|
Junior Member |
|
|
hai
below are my records which already in the database
end_am is varchar2
- date -
- end_am -
- 01-sep-2004 -
- 07:45:00 -
- 02-sep-2004 -
- 08:00:15 -
- 03-sep-2004 -
- 15:30:00 -
- 04-sep-2004 -
- 16:30:30 -
- 05-sep-2004 -
- 11:30:20 -
- 01-oct-2004 -
- 12:15:15 -
- 03-oct-2004 -
- 10:30:16 -
- 05-oct-2004 -
- 14:55:00 -
- 29-oct-2004 -
- 17:20:25 -
i want to produce a monthly report by the end of each month.
when i run my report, it add all the Hours from september to october. let say i want to add for september only not include october. how to do that?
i'm newbies at report
sorry f my example canot be understood
regards
eboy
|
|
|