Please explain how IIF Function works (was Access Help)

[amolbehl]

Can anyone tell me wht this expression does in ACCESS

IIf([Count]>1,([SumOfQty]-[Max])/([Count]-1),[Average]) AS ExcludeOutlierAvg

I Encountered this in a query

I do not Understand [COUNT], [Average] mean

Also in
[SumOfQty], SumOfQty is a field in the table I am trying to access.

Thanx in advance

[missinglinq]

[Count], [SumOfQty], [Max] and [Average] are all field names.

The general syntax is IIf(expression, truepart, falsepart)
If the expression evaluates to True then you do/use the truepart
If the expression evaluates to Flase then you do/use the falsepart

IIf([Count]>1 means
If Count is greater than 1 then
[SumOfQty]-[Max]) / ([Count]-1) AS ExcludeOutlierAvg

If Count is equal to or less than 1 then
[Average] AS ExcludeOutlierAvg

Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

Linq ;0)>

[amolbehl]

I am sorry abt the title .... but actually my q is more on database terms

my query is

SELECT BulkActivity_Max_Min_SubQuery_01.OrderDetail.Item AS Item, Count(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS [Count], Sum(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS SumOfQty, Max(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS [Max], Min(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS [Min], Avg(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS Average, Import_table_for_Planner.units_sold_per_day
FROM BulkActivity_Max_Min_SubQuery_01 INNER JOIN Import_table_for_Planner ON BulkActivity_Max_Min_SubQuery_01.Item = Import_table_for_Planner.Item
GROUP BY BulkActivity_Max_Min_SubQuery_01.OrderDetail.Item, Import_table_for_Planner.units_sold_per_day;
 

check the part

Max(BulkActivity_Max_Min_SubQuery_01.SumOfQty) AS [Max]

is this like a array thing???

because there is a group by.

Could u explain this plz