[AccessD] error in report

Pedro
Are you sure you're referring to the column returned by the report's source
query, not the name of a field on the report?

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Pedro Janssen
> Sent: 28 March 2004 16:43
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] error in report
> 
> 
> 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.
> 
> 
> Pedro Janssen
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
>