SQL supports DATENAME(), but Access ANSI SQL 89 does not support this. I suggest a select case function, like GetMonth()
Public sMonth As String
Function GetMonth(iMonth As Integer)
Select Case iMonth
sMonth = "January"
sMonth = "February"
GetMonth = sMonth
Then just call this from your code (but not your SQL... do it on a form or report Detail on format event.
Yes, just use the query designer and regular expressions in Field line. For example, if you have two names in your table called "LastName" and "FirstName" and you want to display them as one field LastName, FirstName, then in the field line of the query designer, do this:
FullName:([LastName] & ", " & [FirstName])
This will take this:
And display it in the column as
Did that help?