J
jason
Maybe this is what you need to know.....
You would need to name field where the result will show,
then type your formula. For instance,
If you have a query that shows sales for A (A_Sales) and
sales for B (B-Sales), but you want to show total sales
for A and B. You could do the following formula in your
query:
Total_Sales: [A_Sales]+[B_Sales]
you would then have a field named Total_Sales that showed
the result of the formula.
You would need to name field where the result will show,
then type your formula. For instance,
If you have a query that shows sales for A (A_Sales) and
sales for B (B-Sales), but you want to show total sales
for A and B. You could do the following formula in your
query:
Total_Sales: [A_Sales]+[B_Sales]
you would then have a field named Total_Sales that showed
the result of the formula.