We help IT Professionals succeed at work.


yankel1 asked
Medium Priority
Last Modified: 2012-05-06
Please see the sample query I want that the '*' symbol sholud only be there if its not empty
Watch Question

Top Expert 2007

You are more likely to get help if you clearly state your question, and provide an example of where you need help. Many experts - myself included - will not download files, even from EE...
Top Expert 2007

ANd it also helps if your question title is a *bit* less vague...
Both points above by Badotz are very valid. Also a JPEG is better than a DOC or MDB or ZIP

You need to take a look at the IIf() function for what you are trying to achieve, though I don't understand what you are trying to achieve.

Pledge: [Times] & IIf(IsNull([Times]),"","*") & [AmountDivided] & " =" & [AmountPledged]

Cheers, Andrew
Top Expert 2007

>>You need to take a look at the IIf() function for what you are trying to achieve, though I don't understand what you are trying to achieve.

It is difficult to offer suggestions if you do not know what the problem is. I would say, "Better silent and thought a fool then to open one's mouth and remove all doubt."
Personally I would prefer to help new users while pointing out the errors of their ways than just to slap their wrists.
Top Expert 2007

Right. But your comment was gibberish.


TextReport: it works great, I need the same iif for the '=' sign please also I want to have a dollar sign like this 10 * $100 = $1000.

Thanks you
Badotz, your views of another experts postings are irrelevant and you should be more courteous to other experts.

The example I provided showed the use of the IIF() function so that the * was not included in the answer if a [Times] was Null. This gives yankel1 an opportunity to look at the IIF() function with an example that may not be a complete solution to yankel1's question but may stear yankel1 in the right direction. It also gives yankel1 the opportunity expand on the original question.

Regards, Andrew

For the $'s you can use the Format function

Pledge: [Times] & IIf(IsNull([Times]),"","*") & Format([AmountDivided],"$#,##0.00") & " =" & Format([AmountPledged],"$#,##0.00")

Cheers, Andrew

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.