[AccessD] error in report solved

Pedro Janssen pedro at plex.nl
Mon Mar 29 03:14:45 CST 2004


Hello,

i placed the tekst box accidentally on de page footer. Placing it on the
report footer gave the right result.

Pedro Janssen



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Sunday, March 28, 2004 11:48 PM
Subject: Re: [AccessD] error in report


> On 28 Mar 2004 at 17:43, Pedro Janssen wrote:
>
> > Hello group,
> >
> > i use an unbound textbox to calculate the total of a number field in a
report. I used: =Nz(sum([Name of field])) or =sum([Name of field]).
> > When i open the preview i get   #error.  What is wrong.
> >
>
> Did you originally create the textbox by dragging and dropping the
> field into the report? Make sure that the textbox is not named  "Name
> of field".
>
>
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System
> Support.
>
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>





More information about the AccessD mailing list