D
Dan H.
In my data base I am trying to group the total dollars spent by the Qtr they
were spent in. In my form I have one bound field to a table and two unbound
fields that are use for calculations. The bound field is call "Which Qtr"
and Identifies which Qtr a purchase was made. The second unbound feild is
call "TotalEstCost". This a total of all the purchases made on a Credit
card. The last unbound field is call "1stQtrTotal". Its purpose is to
gather all the purchases, dollar amounts, from every credit card during the
1st Qtr or 2nd or 3rd or 4th qtr and total it. In other word I have 4
separate fields for each qtr. I've tried using the IIF statement.
Name: 1stQtrTotal
Control Source: =Sum(IIf([Which Qtr]='1st Qtr',[TotalEstCost],0))
Help.
were spent in. In my form I have one bound field to a table and two unbound
fields that are use for calculations. The bound field is call "Which Qtr"
and Identifies which Qtr a purchase was made. The second unbound feild is
call "TotalEstCost". This a total of all the purchases made on a Credit
card. The last unbound field is call "1stQtrTotal". Its purpose is to
gather all the purchases, dollar amounts, from every credit card during the
1st Qtr or 2nd or 3rd or 4th qtr and total it. In other word I have 4
separate fields for each qtr. I've tried using the IIF statement.
Name: 1stQtrTotal
Control Source: =Sum(IIf([Which Qtr]='1st Qtr',[TotalEstCost],0))
Help.