We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS Access 2007 Query Sum fields

LindaOKSTATE
LindaOKSTATE asked
on
Medium Priority
234 Views
Last Modified: 2012-06-27
With the new feature in MS Access 2007 query columns can be summed directly on the query.  Is there a way to bring these sums over to a report based on that same query?

Thanks,
LindaOKState
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Ok thanks.  I think you are correct though.

Author

Commented:
Is there a way to get a distinct count without adding a subreport?  I have a column that has 26 records, but only four of them are distinct.  is there some way to put syntax in a text box to get a count of the distinct items?  something like =count(distinct[value])?  I know this doesn't work but is there some other way?  I hate to make a new query and subreport for just one number.

Author

Commented:
I added a group header using the column i wanted to count, added a text box with a control source =1, did a running sum overall, made it invisible and then added a text box in the report footer using the text box from the group header as the control source.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.