Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

Query

Please see the sample query I want that the '*' symbol sholud only be there if its not empty
Sample.mdb
0
yankel1
Asked:
yankel1
  • 4
  • 4
1 Solution
 
BadotzCommented:
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...
0
 
BadotzCommented:
ANd it also helps if your question title is a *bit* less vague...
0
 
TextReportCommented:
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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
BadotzCommented:
>>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."
0
 
TextReportCommented:
Personally I would prefer to help new users while pointing out the errors of their ways than just to slap their wrists.
0
 
BadotzCommented:
Right. But your comment was gibberish.
0
 
yankel1Author 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
0
 
TextReportCommented:
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

0
 
TextReportCommented:
For the $'s you can use the Format function

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

Cheers, Andrew
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now