Addendum to original Question:
When I attempt to take the expression that does give me the total I want and create another query (using the query wizard)based on it and the Totals field in my main table that I want to have that value, I get the following error
You have chosen fields from record...
How can I make a calculated expression (Exp1 = BLah blah blah * whatever) give its result to a specific field. When I try to calculate it with Field = Exp1, I get an error. If I try to do the calculating after Field = , I get an error. I can get the numbers I want, but I cannot make it relate to...
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.