Re: [MS_AccessPros] Set the format of table date field to Month only

 

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, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(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:

tblCityHotelRate

CityHotelRateID (key)

CityID

CithHotelRateMonth (I want to format this field in month only)

CityHotelStarID

CityHotelRoomTypeID

CityHotelRate

Best Regards,

Kevin

---

zhaoliqingoffice@163.com

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___