Add to a Script!

[Bob]

=IIf([tbOverDueAmount]>1,"Overdue Amount:",Null)
How Can I add this to the Script <-1"Credit"


Thanks in advance.........Bob Vance

 

[Douglas J. Steele]

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.

 

[Bob]

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.

Explain in words what you're trying to do.


--
Doug Steele, Microsoft Access MVP

(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

 

[Douglas J Steele]

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))


--
Doug Steele, Microsoft Access MVP

(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
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.

Explain in words what you're trying to do.


--
Doug Steele, Microsoft Access MVP

(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

 

[Bob]

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
it's
less than -1, you want "Credit", otherwise you want nothing.

=IIf([tbOverDueAmount]>1,"Overdue
Amount:",IIf([tbOverDueAmount]<-1,"Credit:",Null))


--
Doug Steele, Microsoft Access MVP

(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
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.

Explain in words what you're trying to do.


--
Doug Steele, Microsoft Access MVP

(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