Computing.Net > Forums > Database > MS Access (Year + Period)

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Access (Year + Period)

Reply to Message Icon

Name: kaseyleigh
Date: March 12, 2007 at 09:29:45 Pacific
OS: Win 2003
CPU/Ram: 512
Product: Dell
Comment:

Hi

How can I display a calc field that returns year & period in the format 200701, 200702 etc from fields [yr] and [period]

Ta
Kasey



Sponsored Link
Ads by Google

Response Number 1
Name: rousou
Date: March 12, 2007 at 23:58:33 Pacific
Reply:

=Year(Date) & Right("00" & Month(Date), 2)


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: MS Access (Year + Period)

MS Access 2003 & Time Query www.computing.net/answers/dbase/ms-access-2003-amp-time-query/90.html

Hiding VB Code MS Access www.computing.net/answers/dbase/hiding-vb-code-ms-access/178.html

MS Access 2000 export a record www.computing.net/answers/dbase/ms-access-2000-export-a-record/193.html