F fenhow Registered User. Local time Today, 06:49 Joined Jul 21, 2004 Messages 599 Apr 22, 2016 #1 Hi, is there a way to use the DatePart function to grab the Month and Year only? Thanks. Fen
jdraw Super Moderator Staff member Local time Today, 09:49 Joined Jan 23, 2006 Messages 15,528 Apr 22, 2016 #2 You could use the Month() and Year() functions in Access. More info
S Simon_MT Registered User. Local time Today, 14:49 Joined Feb 26, 2007 Messages 2,176 Apr 22, 2016 #3 To concatenate Format(DateValue,"mmyyyy") Format(DateValue,"yyyymm") Simon
