[AccessD] What to do when subreport used as textbox source has no data

Ron Allen chizotz at charter.net
Wed Oct 8 18:39:25 CDT 2003


Hi Nancy,

The problem, I believe, is that when there is a null value 
the whole expression evaluates to null. I have solved this 
a few ways, but the easiest in most cases is something 
like this: txtAB = iif(Sub1.field,Sub1.field,0) + 
iif(sub2.field,sub2.field,0)- iif(sub3.field, 
sub3.field,0). I work mainly in Acc97, but in Acc2k and 
above there is also a NV function you could look at. This 
isn't perfect for all cases, but it does work for me.

HTH,

Ron



On Wed, 8 Oct 2003 19:00:43 -0400
  "Nancy Lytle" <LYTLEN at peoplepc.com> wrote:
>I have a main report with 3 subreports, all are related 
>by the field
>ProgramCode.  There is a record in three of the reports 
>(Main and 2
>subreports) for every ProgramCode.  I also use the values 
>in the subreports
>to populate a text box - txtAB = Sub1.field + sub2.field- 
>sub3.field -
>sub3.field.  This works fine except for the case where 
>the ProgramCode has
>no record in Subreport3, then that subreport doesn't show 
>and the textbox is
>filled with error#.  How do I get the textbox to use 
>txtAB = Sub1.field +
>sub2.field where there is no sub report for the linked 
>field.
>
>Hope I explained this okay.
>TIA
>Nancy L
>
>N_Lytle at terpalum.umd.edu
>240-274-0069
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system 
>(http://www.grisoft.com).
>Version: 6.0.524 / Virus Database: 321 - Release Date: 
>10/6/2003

<TEXTAREA NAME="Signature" ROWS="4" COLS="60">


More information about the AccessD mailing list