I'm not too sure but according to books online they are usable here is what

books online says

SUM

Returns the sum of all the values, or only the DISTINCT values, in the

expression. SUM can be used with numeric columns only. Null values are

ignored.

Syntax

SUM ( [ ALL | DISTINCT ] expression )

Arguments

ALL

Applies the aggregate function to all values. ALL is the default.

DISTINCT

Specifies that SUM return the sum of unique values.

expression

Is a constant, column, or function, and any combination of arithmetic,

bitwise, and string operators. expression is an expression of the exact

numeric or approximate numeric data type category, except for the bit data

type. Aggregate functions and subqueries are not permitted.

and for iif

IIf

Returns one of two numeric or string values determined by a logical test.

Syntax

Numeric

IIf(«Logical Expression», «Numeric Expression1», «Numeric Expression2»)

This function returns «Numeric Expression1» if «Logical Expression»

evaluates to TRUE, otherwise returns «Numeric Expression2».

String

IIf(«Logical Expression», «String Expression1», «String Expression2»)

This function returns «String Expression1» if «Logical Expression» evaluates

to TRUE, otherwise returns «String Expression2».

check books online for more about these just thought these descriptions

might help, someone will be able to tell you better if this is no good to

you

"Mike" <com> wrote in message

news:google.com...

## Bookmarks