 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2008Expressions in a report
I am trying to get my repeort to show Practice Name and if it is null to print address 1. what expression do I need to write to accomplish this. thanks Grace > I am trying to get my repeort to show Practice Name and if it is null to > print address 1. what expression do I need to write to accomplish this. > thanks Grace Using an unbound control: =IIf(IsNull([Practice Name]),[Address1],[Practice Name])  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail It is a bound control. I need my report to show the Practice Name and if the Practice name is null then I need it to Address 1. Sorry I may have not be clear enough. Thanks so much for your help/ > > I am trying to get my repeort to show Practice Name and if it is null to > > print address 1. what expression do I need to write to accomplish this. > > thanks Grace > > Using an unbound control: > =IIf(IsNull([Practice Name]),[Address1],[Practice Name]) You need to add an unbound control to your report and then set its source to one of the following. =IIf(IsNull([Practice Name]),[Address1],[Practice Name]) or = NZ([Practice Name],[Address 1]) '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > It is a bound control. I need my report to show the Practice Name and if the > Practice name is null then I need it to Address 1. Sorry I may have not be [quoted text clipped - 6 lines] >> Using an unbound control: >> =IIf(IsNull([Practice Name]),[Address1],[Practice Name]) > It is a bound control. I need my report to show the Practice Name and if the > Practice name is null then I need it to Address 1. Sorry I may have not be [quoted text clipped - 6 lines] >> Using an unbound control: >> =IIf(IsNull([Practice Name]),[Address1],[Practice Name]) Yes, I understand [Practice Name] is a bound control. You MUST use an unbound control in the report to do what you wish to do. Just drag a new unbound control where you wish to show the data. Set it's control source to what I suggested. SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail Hi when i use this formula =IIf(IsNull([Practice Name]),[Address1],[Practice Name]) it ask me to enter a para,eter value? what is up with that. > > It is a bound control. I need my report to show the Practice Name and if the > > Practice name is null then I need it to Address 1. Sorry I may have not be [quoted text clipped - 11 lines] > do. Just drag a new unbound control where you wish to show the data. > Set it's control source to what I suggested. > Hi when i use this formula =IIf(IsNull([Practice Name]),[Address1],[Practice > Name]) it ask me to enter a para,eter value? what is up with that. [quoted text clipped - 14 lines] >> do. Just drag a new unbound control where you wish to show the data. >> Set it's control source to what I suggested. If it is asking you fro a parameter, what parameter is it asking for? Practice Name? Address1? Something else? I would suspect you have miss-spelled one of the field names, i.e. [Practice Name] is not the same as [PracticeName]. Also, make sure the name of this control is not the same as the name of any of the fields used in the expression. SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail
|
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.