Footer Calculation to Pull Yearly Data From Date Range

K

Karl Burrows

I have a report that creates subtotals for monthly sales, then another
footer for annual sales and finally a footer for grand totals. Right now,
the yearly subtotal will pull out each year, but how can I differentiate
between a partial year and a full year, It just says for year 2005?

="Summary For " & Format([edtActualClosingDate],"yyyy") & "Lots Sold= " &
Count([LotNumber]) & "Average Lot Price= " &
Format(Avg([LotPrice]),"Currency") & "Total Lot Price = " &
Format(Sum([LotPrice]),"Currency")

Users are required to input a starting and ending date range, but if they
only put in 3/1/2005 to 6/30/2005, how can I tell the report to look at it
and if it is a full year (or year to date) to keep using current syntax and
if it is a partial year to say March 1 to June 30, 2005 for the footer
total?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top