Normally if I want one field totaled I put in a text box with =SUM([product1]) This works great but......
What do you do when you want to total more than one? I tried a text box with =SUM([product1]+[product2]) or =[product1]+[product2] but nothing seems to work.
**a second less imortant question: if the text box for the total is called text9 for example how would I make another text box in the report footer that gives a sum of all the text9's?? If I type =sum([text9]) it prompts me when I open the report and doesn't work at all.**
What do you do when you want to total more than one? I tried a text box with =SUM([product1]+[product2]) or =[product1]+[product2] but nothing seems to work.
**a second less imortant question: if the text box for the total is called text9 for example how would I make another text box in the report footer that gives a sum of all the text9's?? If I type =sum([text9]) it prompts me when I open the report and doesn't work at all.**