If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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". |
|
Thread Tools | |
Display Modes | |
|
|