Report Subtotals - Repost - Thanks!

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 in the subtotal descriptions, 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? Or, if years overlap, it will show yearly totals (example: input
range 7/1/2004 to 6/30/2005 to show 7/1 to 12/31/2004 as a subtotal and 1/1
to 6/30/2005 as a subtotal)

Thanks!
 
S

Sheila D

Hmmm - maybe you could use an IIF statement to say if the time between is
less than 366 do one thing else do something else?

Sheila
 
K

Karl Burrows

How would you use an IFF statement to figure out breaks between years or to
calculate partial years. The report is grouped by year, so I'm not sure how
to tell the footer calculation to tell if it is a whole year or partial year
if the report spans more than one year. Any thoughts on how to get this
started?

Thanks!

Hmmm - maybe you could use an IIF statement to say if the time between is
less than 366 do one thing else do something else?

Sheila
 
S

Sheila D

I see what you mean, bit too difficult for me but hopefully someone else will
pick this up and we can both learn how to do it. Sorry can't help

Sheila

Karl Burrows said:
How would you use an IFF statement to figure out breaks between years or to
calculate partial years. The report is grouped by year, so I'm not sure how
to tell the footer calculation to tell if it is a whole year or partial year
if the report spans more than one year. Any thoughts on how to get this
started?

Thanks!

Hmmm - maybe you could use an IIF statement to say if the time between is
less than 366 do one thing else do something else?

Sheila

Karl Burrows said:
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 in the subtotal descriptions, 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? Or, if years overlap, it will show yearly totals (example: input
range 7/1/2004 to 6/30/2005 to show 7/1 to 12/31/2004 as a subtotal and
1/1
to 6/30/2005 as a subtotal)

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