Expression Formula

[rciolkosz]

I would like to insert a column in my query to add column three plus column
four ONLY if column four is greater than .5

 

[Rick Brandt]

I would like to insert a column in my query to add column three plus
column four ONLY if column four is greater than .5

And what do you want when column four is NOT greater than .5? Just the
value from column three? Nothing? Zero?

For the first...

NewField: Field3 + IIf(Field4 > 0.5, Field4, 0)

 

[raskew via AccessMonster.com]

[hours] + [Mtg] + iif([[Admin]>5, [Admin], 0)

Specifically I need this.

Column Names.

Hours + Admin + Mtg

I only want to include the Admin value if it is >.5 and zero if it is less
than .5
[quoted text clipped - 5 lines]

NewField: Field3 + IIf(Field4 > 0.5, Field4, 0)

 

[fredg]

I would like to insert a column in my query to add column three plus column
four ONLY if column four is greater than .5

What do you wish to get if the value is <=0.5?

NewColumn:IIf([FieldName4] > 0.5, Nz([FieldName3],0) +
[FieldName4],Null)

 

[rciolkosz]

Getting there.

If the Admin field is >5 then I want to add that number into the equation.
ex. if the number in the admin field is say 8 then I would add 3 to the
other two columns.

[hours] + [Mtg] + iif([[Admin]>5, [Admin], 0)

Specifically I need this.

Column Names.

Hours + Admin + Mtg

I only want to include the Admin value if it is >.5 and zero if it is less
than .5

I would like to insert a column in my query to add column three plus
column four ONLY if column four is greater than .5

[quoted text clipped - 5 lines]

NewField: Field3 + IIf(Field4 > 0.5, Field4, 0)

 

[raskew via AccessMonster.com]

[hours] + [Mtg] + iif([[Admin]>5, [Admin] - 5, 0)

Getting there.

If the Admin field is >5 then I want to add that number into the equation.
ex. if the number in the admin field is say 8 then I would add 3 to the
other two columns.

[hours] + [Mtg] + iif([[Admin]>5, [Admin], 0)

[quoted text clipped - 12 lines]