Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reports Labels 1

Status
Not open for further replies.
davoakey

davoakey

Technical User
Jan 24, 2005
25
GB
In a report invoice, how do I make a label in the header called "Credit Note" visible or invisible depending on the total of the invoice, minus amount make visible, and plus amount invisible.
 
Sort by date Sort by votes
davoakey
Here's one approach.

In your report, put an unbound text box (not a label).
=IIf([YourInvoiceTotalControl]<0,"Please note...you have a Credit balance!","")

Change the text to whatever you want.

Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmcate
  • Locked
  • Question
Report to Filter each employer to create induvial PDF reports
Replies
2
Views
203
lmcate
lmcate
tiffjones001
  • Locked
  • Question
Creating database for Data Entry, Reports - how to set up the tables?
Replies
3
Views
55
dhookom
dhookom
desi5pure
  • Locked
  • Question
MS Access reports export to Excel
Replies
2
Views
70
Lost500
Lost500
cyberBI
  • Locked
  • Question
MS Access error 283806 when opening reports
Replies
2
Views
107
cyberBI
cyberBI
naoaja
  • Locked
  • Question
Structure query for labels
Replies
1
Views
32
naoaja
naoaja

Part and Inventory Search

Sponsor

Back
Top