Results 1 to 2 of 2
  1. 03-23-2010, 10:19 AM #1
    nkuebelbeck
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 97
    Join Date
    Mar 2010
    Posts
    91

    format

    I am using access 97, and trying to do a sort by month. I can return the month number(ex march=3) Now how do I display the month name instead of the number?



    Thanks
    Reply With Quote Reply With Quote
  2. 03-23-2010, 10:22 AM #2
    nkuebelbeck
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 97
    Join Date
    Mar 2010
    Posts
    91

    noob

    got it

    month: Format([Entry Date],"mmmm")
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Retaining format
    By tlmackey in forum Import/Export Data
    Replies: 0
    Last Post: 02-25-2010, 03:42 PM
  2. date format
    By dollygg in forum Access
    Replies: 2
    Last Post: 01-19-2010, 10:14 AM
  3. Please Help, How Do I Format this Data?
    By txdave36 in forum Access
    Replies: 6
    Last Post: 09-09-2009, 04:31 PM
  4. Text Box Format
    By Scott in forum Forms
    Replies: 0
    Last Post: 01-09-2008, 11:13 PM
  5. Date Format
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-15-2006, 01:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums