Crosstab query dynamic columns ala Duane Hookom

Got it!!! I used a combination of both of your suggestions:

=IIf(Nz([A]),Sum(IIf((IsNumeric([A])),Val([A]),0)))

and it does what I need. Thanks so much!!!
--
javablood


"John Spencer" wrote:

Try
=Sum(IIF(IsNumeric([Result],Val([Result]),Null))

That should sum only results that can be interpreted as numbers. So Nulls are
not numeric and "25U" is not numeric and "" is not numeric and therefore none
of them get summed.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Duane Hookom wrote:
Your dates should actually be columns with names like [A], [b], etc. Are you
unable to sum these columns in group or report footer sections? Did you try
use something like:
=Sum(Val(Nz([A],0)))

I'm not understanding what you want to do with Result = "25U".