year-to-date totals in query or report

[cochise]

I have a report that is based on a query that calculates sales, percent total sales, # invoices, % invoices, etc... by city. The report right now calculates the data for a month period. I would like that same report to have year to date values for various fields. Does anyone know how I can do this or could someone point me to a good source?

 

[DougP]

you could make a separate SUB report at the bottom of the main report that looked a new query which was just year to date totals.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[cochise]

I actually wanted to include it in my main report, not a sub report.

 

[LDeMaio]

Use the DSUM function. Place it in the Control Source property. Here is an example.

=DSum("[Hours]","tHistorySummary","[year] = " & [iYear] & " and [CustNo] ='" & [CustomerNo] & "'&quot

This example sums up the hours for a customer in a year. Remove the customer criteria and you will get the totals hours for all.

I use this in a report and it works just fine. It will work in a form just the same. Just remember, it is just like running an added query in the report. Depending upon the number of records it will add time to the report execution.

Larry DeMaio
SDC