[AccessD] Setting Control Source of a Group to Numeric in a Report

D'oh.  You don't know how many times that  =  has tripped me up.


Thanks Gustav.



Rocky

----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, June 21, 2004 9:38 AM
Subject: Re: [AccessD] Setting Control Source of a Group to Numeric in a
Report


> Hi Rocky
>
> Shouldn't it be:
>
>   =Val(Nz([fldUDF1]))
>
> /gustav
>
>
> > I have a report which may be sorted on one of ten user defined fields
which may be holding alphanumeric, numeric, or date data.
>
> > If it is numeric I want the control source of that grouping level to be
Val(Nz([fldUDF1]))
>
> > But if I set it either through the sorting and grouping property sheet
or through code it generates an error 'Extra ) in query expression
'[Val(Nz([fldUDF1]))]' which is not what it means because
> > the parentheses are balanced.
>
> > Am I trying to do something which cannot be done?
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com