|
| | | Forum Newbie
Group: Forum Members
Last Login: 9/28/2009 5:34:43 PM
Posts: 4, Visits: 11 |
| | I am connecting to Oracle through MS QUERY. The result is put into excel. Set Query = QuerySheet.QueryTables("MONEY")
Query.Sql = "SELECT NUMB_TBLE.NUMB_NAME, TO_CHAR(NUMB_DATES_TBLE.DAY_MTH_YR, 'MONTH'), SUM(NUMB_TBLE.NUMB_PAY) " _
& "FROM JES.NUMB TBLE NUMB TBLE,
JES.NUMB_DATES_TBLE NUMB_DATES_TBLE" _
& "WHERE NUMB_TBLE.NUMB_ID = NUMB_DATES_TBLE.NUMB_ID AND NUMB_TBLE.NUMB_CODE IN (" & NumList & ") " _
& "Group by numb_tble.numb_name, TO_CHAR(NUMB_DATES_TBLE.DAY_MTH_YR, 'MONTH')
ORDER BY TO_CHAR(NUMB_DATES_TBLE.DAY_MTH_YR, 'MONTH') This doesn't accomplish what I want In my query, I want to display the month in words
I want to order the month by number For example the result would be Jones January 10.00
Doe April 20.00 How do I do this? |
| |
|
|