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 > >