I am creating a report using access database. How can i querry the database to calculate the totals of each field in the query
-
-
If the your 'report' is the main thrust of this question then you could show the group headers or group footers in the report and mount an unbound textbox that 'counts' or 'sums' on the value of whatever field is appropriate for you to count on. For instance if you have a field on your report called customerID and you were grouping by cutsomer category then using =Count([CustomerID]) as the controlsource for the textbox (a calculated control basically) would give you the number of customers in that group. So in short the report can provide you with the mechanism in itself for 'counting' or 'summing' some of what you may require.Originally posted by mugo
Jim :)
Comment