Link to home
Start Free TrialLog in
Avatar of LindaOKSTATE
LindaOKSTATEFlag for United States of America

asked on

MS Access 2007 Query Sum fields

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
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LindaOKSTATE

ASKER

Ok thanks.  I think you are correct though.
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.
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.