 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2008Line Break
I can't seem to break this into two lines...also is there a better, or shorter way to code this? Thanks DS Me.TxtNone = Round(IIf(CDTaxCodeID = 2, Nz(DSum("(CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP", "CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID = 2"), 0), _ Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"), 0), 1)) What do you mean, break it into two lines?  SignatureDave Hargis, Microsoft Access MVP > I can't seem to break this into two lines...also is there a better, or > shorter way to code this? [quoted text clipped - 9 lines] > 1)) > I want the code to be on two seperate lines. Thanks DS You have a line continuation character _ already in the code. Are you getting an error? Can you provide more detail, please? SignatureDave Hargis, Microsoft Access MVP > I want the code to be on two seperate lines. > Thanks > DS A short version, Me.TxtField = DSum("Field","tblAll") + DSum("Field","tblSome") This is too long so to view so I want to put the DSums on seperate lines. Me.TxtField = DSum("Field","tblAll") + DSum("Field","tblSome") How would I do this? Thanks DS Me.TxtField = DSum("Field","tblAll") _ + DSum("Field","tblSome") But I still don't see the problem with the long version. As I said, you already have the line continuation character. I can't very well help if you wont say what the problem is. SignatureDave Hargis, Microsoft Access MVP > A short version, > Me.TxtField = DSum("Field","tblAll") + DSum("Field","tblSome") [quoted text clipped - 7 lines] > Thanks > DS The second line is in red.... Thank DS Syntax is incorrect. See if this works. Me.TxtNone = Round(IIf(CDTaxCodeID = 2, Nz(DSum("CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP", "CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID = 2"), 0), _ Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"), 0), 1)) SignatureDave Hargis, Microsoft Access MVP > The second line is in red.... > Thank > DS Thanks Still In Red. DS Me.TxtNone = Round(IIf(CDTaxCodeID = 2, _ Nz(DSum("CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP", _ "CDCheckID = " & Forms!Form2!TxtCheckID & _ " AND CDDiscountDP = 0 AND CDTaxCodeID = 2"), 0), _ Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = " & _ Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"), 0), 1)) SignatureDave Hargis, Microsoft Access MVP > Thanks > Still In Red. > DS |
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.