wookie Posted March 27, 2003 Share Posted March 27, 2003 Does anyone know a trick how to add comments to formulas? I have some pretty complicated and long formulas which I would love to comment here and there, just in case I have re-adjust them at any later time. [color:"#666666"](Please don't recommend to use sub-formulas - this databases already has 180 fields and I don't want to create even more) Link to comment Share on other sites More sharing options...
Lee Smith Posted March 27, 2003 Share Posted March 27, 2003 Hi Wookie This came up on another list and here are some of the suggestions that came out of it. 1. External("Comment", " Your comment here " ) 2. Number type: + Case("this is a comment" = 0, 0, 0) 3. Text type: & Left("this is a comment", 0) 4. If(0, "This is where I type my comment about the calculation formula", calc formula goes here...) HTH Lee Link to comment Share on other sites More sharing options...
Chuck Posted March 27, 2003 Share Posted March 27, 2003 Use the left function, as in: Left( "Your comment here", 0 ) & TheRestOfYourCalc'sFormula This will work if your calc's result is text. Use something like: Length( Left( "Your comment here", 0 ) ) + RestOfCalc If the result is date, time or number. Chuck Link to comment Share on other sites More sharing options...
wookie Posted March 27, 2003 Author Share Posted March 27, 2003 Thanks for the rapid response! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7867 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now