<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...sounds like an IIF to me :)))</FONT></DIV>
<DIV> </DIV>
<DIV>William Hindman<BR><<A
href="http://www.freestateproject.org">http://www.freestateproject.org</A>> -
Do you want liberty in your lifetime?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=LYTLEN@peoplepc.com href="mailto:LYTLEN@peoplepc.com">Nancy Lytle</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=AccessD@databaseadvisors.com
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, October 08, 2003 7:00
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] What to do when
subreport used as textbox source has no data</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>
<DIV>I have a main report with 3 subreports, all are related by the
field<BR>ProgramCode. There is a record in three of the reports (Main
and 2<BR>subreports) for every ProgramCode. I also use the values in the
subreports<BR>to populate a text box - txtAB = Sub1.field + sub2.field-
sub3.field -<BR>sub3.field. This works fine except for the case where
the ProgramCode has<BR>no record in Subreport3, then that subreport doesn't
show and the textbox is<BR>filled with error#. How do I get the textbox
to use txtAB = Sub1.field +<BR>sub2.field where there is no sub report for the
linked field.<BR><BR>Hope I explained this okay.<BR>TIA<BR>Nancy
L</DIV></FONT></DIV><FONT face=Arial size=2>
<DIV><BR><A
href="mailto:N_Lytle@terpalum.umd.edu">N_Lytle@terpalum.umd.edu</A><BR>240-274-0069</DIV>
<DIV> </DIV>
<DIV><BR>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by AVG
anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: 6.0.524
/ Virus Database: 321 - Release Date: 10/6/2003</FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>