Search results for query: *

wow you are honestly a genius...I was barely able to understand my own crazy IF's and somehow you made sense of it and got it to work.. amazing much appreciated.

I began to convert it to VBA: Public Function GetVal(BegTaxBasis As Variant, Contribution As Variant, Distribution As Variant, TaxIncSubTotal As Variant, TBBLL As Variant, Recourse As Variant, QualifiedNonRecourse As Variant, NonRecourse As Variant) As Long Dim TRQN As Long TQRN = TBBLL +...

oh wow that is really helpful thank you!! Can you by chance help me with the first section as well I want to convert that into VBA IF- Then's: IIf([BegTaxBasis]=0 And [Contribution]+[Distribution]=0,0,IIf([BegTaxBasis]=0 And...

GainRecDistr: IIf([BegTaxBasis]=0 And [Contribution]+[Distribution]=0,0,IIf([BegTaxBasis]=0 And...

Thanks for your help! When I try to run that it gives me a compile error: see image attached. http://files.engineering.com/getfile.aspx?folder=5fe027ed-93b6-4687-9e80-479b6fe39172&file=Capture.PNG

I have a query in Access Database and when I try to run it, I get an error message "query is too complex to run." Runtime error 3360." The problem is with one formula / programming logic, see below: Previously the formula was the below - and it worked. IIf([BegTaxBasis]=0 And...