Newbies monki_sf Posted August 24, 2005 Newbies Posted August 24, 2005 Hi, I've created the following calculation resulting in text but can't figure out how to write this so that if there is no data in the second field that the seperators "///" are not added in the result and only the field one data is displayed. can anyone help with this? calculation: field1 & "///" & field2
SlimJim Posted August 24, 2005 Posted August 24, 2005 This should work field1 & If(IsEmpty(field2);"";"///" & field2)
Newbies monki_sf Posted August 24, 2005 Author Newbies Posted August 24, 2005 i knew it had to be something as easy as that - thanks a million it works perfectly
Recommended Posts
This topic is 7099 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