Recent content by dltoney2

I have created a series of pie charts in reports based on queries. The data that is being charted are agree, strongly agree, neither agree nor disagree, disagree, and strongly disagree. I want the colors for these to be consistent in all the pie charts but they are coming out different colors...

Thank you!! Works PERFECT. This is my very first post at this website and I am so thrilled that you have been so very helpful and quick about it too!!!! You rock!!!! Thank you, thank you.

Thank you for the timely response. This does exactly what I asked for, but I see I needed to ask for a bit more. In addition to the following code that you supplied, for those AI Values less than or equal to 999 I need a Null value (the field is empty). Where would that part of the code go...

I have an expression that sets an AI Buy It Now value that is 125% of AI Value and rounds it, which follows AI Buy It Now: Round(([AI Value]*1.25)/10)*10 I need to add to this expression that I only want this calculation applied if AI Values are greater than 999. But I can't figure out how to...