VWLP Posted July 5, 2012 Share Posted July 5, 2012 I am having difficulty finding the right formula to allow multiple record descriptions in the same column. For example, I set the criteria of the first row to show all items with Record A and Record B. In column A I would like to show the item description. I was able to show the description for Record A by using the formula ='Record A'.'description' . However, I would also like to include the description for record B in the same column. How should I modify this? I also have a bonus question of a function that probably is not possible, but it's worth a shot to ask. Is it possible to set items of a certain record to automatically show up in a different font color in the database? Thank you. Quote Link to comment
michaelk Posted July 5, 2012 Share Posted July 5, 2012 It's not clear from your question: Do some objects have A and some have B or do they have both? See the attached example. I think it answers your question. Bonus answer: No. hth mk Quote Link to comment
VWLP Posted July 5, 2012 Author Share Posted July 5, 2012 Michael, thank you for your response. To clarify my example, objects will have either A or B records, but not both. I am using VW2011 and for some reason was unable to open the attached file. If it's not too much trouble, would it be possible to take a screenshot or paste the example formula? Quote Link to comment
Pat Stanford Posted July 5, 2012 Share Posted July 5, 2012 Separate Records are going to make it challenging as you will have to define a criteria set that gets all of the objects that you need in the schedule. As long as none of them have both records, you should be able to do something like: =('Record A'.'description' | 'Record B'.'description') where the vertical bar acts as a logical "OR" Quote Link to comment
VWLP Posted July 5, 2012 Author Share Posted July 5, 2012 Thank you, Pat. Your formula makes sense, but it is not working for me in practice. I followed it exactly and am getting the #VALUE! error. I'm attaching an example in case anyone can figure out what is wrong. Thanks, Lindsay Quote Link to comment
VWLP Posted July 6, 2012 Author Share Posted July 6, 2012 Thanks Michael, your example completely helped! I was able to use your formulas to work in my own database. Thanks to both of you for the assistance. Quote Link to comment
michaelk Posted July 6, 2012 Share Posted July 6, 2012 Glad to help. It's helpful to put your VW version and computer OS in your signature. It's under My Stuff > Edit Profile at the top of this page. mk Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.