Thanks, George. I was playing with nz on the main form, but maybe I
need to use it on the subform instead and just get the results of
that onto the main form. I appreciate the help. Jim
--- In AccessDevelopers@yahoogroups.com, "George Oro" <[EMAIL PROTECTED]>
wrote:
> I believed at the moment this is the value of the total field of
your sub
> form:
> Control Source = Sum([MyValue])
>
> try this:
> Control Source = nz(Sum([MyValue]),0)
>
> HTH
> George
>
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com
> [mailto:[EMAIL PROTECTED] Behalf Of jmw95823
> Sent: Wednesday, July 13, 2005 1:33 AM
> To: AccessDevelopers@yahoogroups.com
> Subject: [AccessDevelopers] Re: This is easy, but I forgot how to
do it:
> Show main form calculation as $0
>
>
> I just moved my subform which performs the calculation up to the
text
> box area and replaced it with the subform. Now I either get the
> calculation or a blank if no subform data, so that will be okay for
> now anyway.
> --- In AccessDevelopers@yahoogroups.com, "jmw95823" <[EMAIL PROTECTED]>
> wrote:
> > I have a field on my main form which shows the sum of $$ from
> records
> > on subform by common ID. If there are no records on subform, I
want
> > to show $0 in my main form text field instead of #Error or blank.
> > Any help in reviving my memory will be appreciated. Thanks. Jim
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
