TOTALS IN ACCESS REPORT

[khurley]

Hi Folks,

I have what I hope is going to be a simple question.

I have a query that uses criteria to give me a subset of data that i want to display on a report.

I want to total the premium dollars on this report. Thats easy.

i'd aslo like to show the TOTAL premium for all records in the table. not just the subset.

Is there an easy way to get this data on the report?? I am having trouble trying to figure it out.

Any help would be great!

Thanks!
Kathy

 

[Remou]

DSum is probably what you need.

 

[dhookom]

DSum() might be the simplest but other options are
- subreport
- if your totals query has only one record then just add it to the record source query
- code

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]