We help IT Professionals succeed at work.

Query

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

Top Expert 2007

Commented:
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

Commented:
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

Commented:
>>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

Commented:
Right. But your comment was gibberish.

Author

Commented:
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.

OR

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.