antonyx Arsenal Supporter Local time Today, 03:21 Joined Jan 7, 2005 Messages 556 Jan 22, 2007 #1 hi.. im sure this cant be that difficult.. is it possible to add a where clause to this control source of a textbox.. basically i want to add 'if jobtype=1' to this.. Code: =Sum([JobTdFare])
hi.. im sure this cant be that difficult.. is it possible to add a where clause to this control source of a textbox.. basically i want to add 'if jobtype=1' to this.. Code: =Sum([JobTdFare])
boblarson Smeghead Local time Yesterday, 19:21 Joined Jan 12, 2001 Messages 32,040 Jan 22, 2007 #2 Code: =Sum(IIf([JobType]=1,[JobTdFare],0))
antonyx Arsenal Supporter Local time Today, 03:21 Joined Jan 7, 2005 Messages 556 Jan 22, 2007 #3 thats the one.. thanks.. i knew it was something like that
