John-
What if it's date field? e.g. CheckinDate? Is this ok?
?Month(CheckinDate)
Kevin
zhaoliqingoffice@163.com
Date: 2015-11-04 19:59Subject: Re: [MS_AccessPros] Set the format of table date field to Month onlyKevin-
Use the Month function.?Month(#2015-11-20#)11John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Nov 4, 2015, at 12:23 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:John-
I see. Then if I want to compare this month field with a date field, I have to convert a date field to a number, right? e.g. how to convert 20-Nov-2015 to number 11? Thanks,
Kevin
在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月4日 下午6:57写道：Kevin-
If you use a date/time field, then you must store either a full date (year, month, day) or a time (hh:mm:ss) or both. Why not use an integer field for the month number or a text field for the month name?John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Nov 4, 2015, at 11:33 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:Dear All,I am designing a table with a date field. I want have this field in month only format. Is that possible? Here's the table:tblCityHotelRateCityHotelRateID (key)CityIDCithHotelRateMonth (I want to format this field in month only)CityHotelStarIDCityHotelRoomTypeIDCityHotelRateBest Regards,Kevin
__._,_.___
Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar