Joe- You're mixing apples and oranges. The Month function returns an integer: 1 - 12. If you want the month name, you must use the Format function.
Format([DOI], "mmmm") or Format([DOI], "mmm") The first displays the full name, as in "January". The second displays the month abbreviation, as in "Jan". If you want to filter on the month number, apply the filter to the expression Month([DOI]). You can put both expressions in the same query as long as you assign a different name to each output field. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Monday, January 09, 2006 2:43 PM To: [email protected] Subject: [ms_access] ?? on Month Description ?? Hi, Same query as last question. But trying to display month description. I put a text box on the report with the contro source being the Month:Month([DOI]) from the query where DOI is a date I put mmmm if the format of the texbox. I run the report for January, putting in a 1, But get December as the month? I also tried to display Month(DOI]) on the report and get 1 Thanks Joe Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
