W wop0703 Registered User. Local time Today, 12:52 Joined Jun 1, 2005 Messages 77 Jun 10, 2005 #1 I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?
I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?
C cheuschober Muse of Fire Local time Today, 12:52 Joined Oct 25, 2004 Messages 168 Jun 10, 2005 #2 wop0703 said: I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax? Click to expand... Look in the help under 'format date.' You shouldn't ever need to change the date from a numeric to a text field in a query. Use the format property in your form or report to handle this operation. Regards, ~Chad
wop0703 said: I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax? Click to expand... Look in the help under 'format date.' You shouldn't ever need to change the date from a numeric to a text field in a query. Use the format property in your form or report to handle this operation. Regards, ~Chad
