View Single Post
 
Old 12-11-2017, 11:29 AM
kbboykin kbboykin is offline
Senior Member
 
Join Date: May 2005
Posts: 367
Default Solved

@Norrit. I am using the Jet 4.0 database. I have subsequently learned that it will not support MonthName function, only Ace engine will. Nonetheless, I have found the solution from Kobik at stackoverflow.com.

SELECT Format(hmonth * 30, 'MMM') AS MName, *
FROM provhedis
ORDER BY hyear, hmonth, provlastname;

This will give me the correct Month Name based on the month integer that is stored in my table, when I run the query against it.
__________________
Using Delphi 2010 Professional as a Novice Programmer - self taught
Reply With Quote