 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006Add to a Script!
=IIf([tbOverDueAmount]>1,"Overdue Amount:",Null) How Can I add this to the Script <-1"Credit" Thanks in advance.........Bob Vance Bob: You've asked this before. If you didn't get a response, it's because your question isn't clear. Explain in words what you're trying to do.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > =IIf([tbOverDueAmount]>1,"Overdue Amount:",Null) > How Can I add this to the Script <-1"Credit" > > Thanks in advance.........Bob Vance What I want to do is display "Overdue Amount" When There is more than $1 showing and if there is more than ($1) credit showing the word "Credit" to appear. The text box that the Amounts appear in is called tbOverDueAmount Thanks Bob > Bob: You've asked this before. If you didn't get a response, it's because > your question isn't clear. [quoted text clipped - 5 lines] >> >> Thanks in advance.........Bob Vance Not the greatest description. I'm assuming that you're talking that if the field tbOverDueAmount is greater than 1, you want "Overdue Amount", if it's less than -1, you want "Credit", otherwise you want nothing. =IIf([tbOverDueAmount]>1,"Overdue Amount:",IIf([tbOverDueAmount]<-1,"Credit:",Null)) SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > What I want to do is display "Overdue Amount" When There is more than $1 > showing and if there is more than ($1) credit showing the word "Credit" to [quoted text clipped - 10 lines] > >> > >> Thanks in advance.........Bob Vance Absolutely Brilliant, that's it thanks Douglas...Bob > Not the greatest description. I'm assuming that you're talking that if the > field tbOverDueAmount is greater than 1, you want "Overdue Amount", if [quoted text clipped - 20 lines] >> >> >> >> Thanks in advance.........Bob Vance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.