Totals w/ filter on Report or Form

  • Thread starter Thread starter MadCSS
  • Start date Start date
M

MadCSS

Hello--

I am new to Access and have sucessfully found a way to add a ¨Totals¨ row to
my table (just from the ¨Totals¨ button on the toolbar). I also discovered
that I can filter my data and the total changes according to the filtered
data, which is exactly what I need, but how can I do this on a Report so that
I can print the results?

Essentially, I would like users be able to filter data (from a table listing
all of the repairs for all of our vehicules) so that they can view total
costs of specific vehicles.

Am completely unfamiliar with coding and would rather stay clear of that,
but there must be a way to do this! Thanks in advance! :)
 
Hello--

I am new to Access and have sucessfully found a way to add a ¨Totals¨ row to
my table (just from the ¨Totals¨ button on the toolbar). I also discovered
that I can filter my data and the total changes according to the filtered
data, which is exactly what I need, but how can I do this on a Report so that
I can print the results?

Essentially, I would like users be able to filter data (from a table listing
all of the repairs for all of our vehicules) so that they can view total
costs of specific vehicles.

Am completely unfamiliar with coding and would rather stay clear of that,
but there must be a way to do this! Thanks in advance! :)
Click to expand...

You are mixing levels. Tables do not and should not contain Totals rows!

Tables are for storing data. That's ALL that tables are for.

Queries are used to select, sort, and arrange data.

Reports are used to print data.

I would suggest using a Query to pull together the data that you want to see -
including criteria to allow the users to filter the data by vehicle or
whatever other criteria are appropriate; and base a Report on that query. On a
Report you can use the "Sorting and Grouping" feature to create group headers
and footers; you can put a textbox in a group Footer (or header, actually)
with a control source

=Sum([cost])

to do the subtotals or grand totals right in the Report. No code is needed.
 
Back
Top