Add another column to your query (third in this example).
First column: TaxRate
Second column: TaxableIncome
Third column: TaxDue: ([TaxRate] * [TaxableIncome])
HTH
---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.
I am very new to this so I probably did not explain myself well.
I have two columns in my query that have numbers in them.
I want to just have a total of each column and divide it by a certain number of days to come up with a average number for those days. How can I do that and where will it display?
You can do it in a separate query, using the appropriate SUM([yourfield]) or AVG([yourfield]) aggregate functions. Use GROUP BY to aggregate the columns desired.
If you need more help, post more details about what you're trying to accomplish and someone will try to point you in the right direction.
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
You could also put those formulas into the report instead of putting them in a separate query.
If you want to hard code a number that is used as the divisor:
Divide30: Sum([ThisTable]![TaxableIncome])/30
BTW Greg - great quote!
---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.