[AccessD] error in report

Hello Andy,

i don't know exactly what you mean with: referring to the column returned by
the report's source query, but i refer to the name that is in the original
table and the query.  I can see that name in the Field List.

Pedro Janssen





----- Original Message -----
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Sunday, March 28, 2004 5:57 PM
Subject: RE: [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
> >
> >
> >
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>