Re: Report Subtotals - Repost - Thanks!

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!

"Sheila D" <SheilaD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F3122CFC-E131-42BB-85BC-5D076DF2C09D@xxxxxxxxxxxxxxxx
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" wrote:

> 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!
>
>
>


.

Relevant Pages

  • Re: errors in Crystal Reports .NET subtotals and grand totals
    ... the grand total does not match the sum of the subtotals... ... Subtotals and grand totals sum EVERY detail record ... whether or not they actually appear on the report. ... setting the conditional calculation to perform only when the section is ...
    (microsoft.public.vb.crystal)
  • Re: Report Subtotals - Repost - Thanks!
    ... The report is grouped by year, ... >> I have a report that creates subtotals for monthly sales, ... >> footer for annual sales and finally a footer for grand totals. ...
    (microsoft.public.access.reports)
  • Re: Access XP/2003 & Subforms challenge
    ... >them in the footer of the subform as you're supposed to. ... >subtotals and totals are calculating correctly. ... report to obtain the same total. ...
    (microsoft.public.access.forms)
  • Design reports with formulas
    ... I created a report that totals three different types of space in two ... different buildings. ... I was able to create subtotals for each type of space ... I created a text box at the bottom of the report in the report ...
    (microsoft.public.access.gettingstarted)
  • Re: subreport/report total question
    ... it gives me the exact same totals as ... the job footer should do). ... In the subreport, move your DayTotal text box into the Report Footer ... Page Header ...
    (microsoft.public.access.reports)
Loading