Re: IIf or Nz function
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Thu, 10 Aug 2006 00:32:46 +0800
See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html
The article explains how to test the HasData property of the subreport, and
why that's necessary.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"JoeA2006" <JoeA2006@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9AB35B05-5D1C-4E4D-9CF2-410747A0A6FA@xxxxxxxxxxxxxxxx
I need to use a total from a subreport that may or may not have data for a
calculation. The Nz and IIf functions seem to work when the subform show
up
on the main form, however one form does not show up and when I use the IIf
or
Nz function I still get an error. Why do other objects show and this one
does
not?The calculation seems to work on the accompanying report, but will not
work on the main form.
.
- Prev by Date: Re: Multiple Autonumbers To Select From On Form
- Next by Date: Re: URGENT! Link two field of different forms
- Previous by thread: form buttons
- Next by thread: Re: IIf or Nz function
- Index(es):
