Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / November 2005

Tip: Looking for answers? Try searching our database.

Expression Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cc@DMA - 30 Nov 2005 18:01 GMT
I'm trying to write an expression that will convert a number into
year/month/day format based on 365 day year, and 30 day months. For example
366 should read:
"1 year, 0 months, 1 day". I've been told I have to hard-code this. How do I
get into the code behind an expression?
[MVP] S.Clark - 30 Nov 2005 19:11 GMT
Alt + F11 opens the VBA editor.  Any clue what recursion programming is?

In order to understand recursion, you must first understand recursion. :)

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

> I'm trying to write an expression that will convert a number into
> year/month/day format based on 365 day year, and 30 day months. For
[quoted text clipped - 3 lines]
> I
> get into the code behind an expression?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.