Make statement alittle bit shorter!

J

JOM

I have the following statement on my report, is there a way tha I could make
it a little bit shorter so that it does not crash...

=Abs(Sum(IIf([TaxDocStatus]="Complete",(IIf((([TaxDocName] In ("W2","1099"))
And
DateDiff("d",[RqstDateRcvd],[TxDocDateRcvd])-DateDiff("ww",[TxDocDateRcvd],[RqstDateRcvd],7)-DateDiff("ww",[TxDocDateRcvd],[RqstDateRcvd],1)-DCount("*","Holiday","HdyDate
Between #" & [RqstDateRcvd] & "# And #" & [txDocDateRcvd] &
"#")<=10),1,0)))))
 
H

Homer J Simpson

I have the following statement on my report, is there a way tha I could
make
it a little bit shorter so that it does not crash...

=Abs(Sum(IIf([TaxDocStatus]="Complete",(IIf((([TaxDocName] In
("W2","1099"))
And
DateDiff("d",[RqstDateRcvd],[TxDocDateRcvd])-DateDiff("ww",[TxDocDateRcvd],[RqstDateRcvd],7)-DateDiff("ww",[TxDocDateRcvd],[RqstDateRcvd],1)-DCount("*","Holiday","HdyDate
Between #" & [RqstDateRcvd] & "# And #" & [txDocDateRcvd] &
"#")<=10),1,0)))))

Is it possible to write this as a function in VBA which you call from the
report?
 

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

Top