R
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
four ONLY if column four is greater than .5
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
rciolkosz said: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)
R
rciolkosz
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
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
F
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)
R
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.
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.
raskew via AccessMonster.com said:[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]I would like to insert a column in my query to add column three plus
column four ONLY if column four is greater than .5NewField: Field3 + IIf(Field4 > 0.5, Field4, 0)