![]() |
|
|
|||||||
![]() |
Microsoft Certification - date formatting in Access |
|
|
Thread Tools | Search this Thread |
|
|
#1 |
|
I wish to format a column for month and year only. These dates include prior
years and the current year. When I select "date/time" and format it mm/yy and type in a prior year like 11/05, (november 2005) Access changes 05 to 06, the current year. Even when I select "Number" as the type of entry, and format it the same, mm/yy it does the same thing coverting all pervious years to 06. I want to be able to sort by date assending or desending and these items only have month and year. I can do it with two separate number columns, one for year and one for month, but that requires two sorts which is not as quick an easy as I would like. =?Utf-8?B?amhoYXJyaXM=?= |
|
|
![]() |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I cant access the MCP site | T3M4N | MCTS | 1 | 03-18-2008 06:21 PM |
| Cannot access one URL | Elke | General Help Related Topics | 1 | 12-02-2006 11:36 AM |
| MS Access not recognising Date() function | tessythampan | Software | 0 | 08-28-2006 11:51 AM |
| Access Date/time to SQL to only show Date | Whothehell | Software | 2 | 07-27-2006 06:11 PM |
| requesting a hand up - read for your Mom [short message with Quotes] | Miss Marple | DVD Video | 1 | 03-17-2005 10:07 PM |