LindaOKSTATE
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
Thanks,
LindaOKState
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.
ASKER