Add another senario

B

Bob Vance

Can I add this into my code, <1 , "Credit"

=IIf([tb1Month]>1,"1 Month Overdue",Null)
 
P

pietlinden

Can I add this into my code,  <1 , "Credit"

=IIf([tb1Month]>1,"1 Month Overdue",Null)
Click to expand...

=IIf([tb1Month]>1,"1 Month Overdue",IIf([tb1Month]<1,"Credit",Null))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Order of code 3
Need some PWA help 0
Adding sequence numbers to paragraphs 0
Add a Credit to Script 1
Add to a query Expression! 9
Error when opening a my Query 5
Report Error "Database Engine" 5
More than one ondedrive on the same computer 0

Top