Re: Report Subtotals - Repost - Thanks!
- From: "Sheila D" <SheilaD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Aug 2005 02:00:03 -0700
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" wrote:
> 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!
> >
> >
> >
>
>
>
.
- References:
- Report Subtotals - Repost - Thanks!
- From: Karl Burrows
- RE: Report Subtotals - Repost - Thanks!
- From: Sheila D
- Re: Report Subtotals - Repost - Thanks!
- From: Karl Burrows
- Report Subtotals - Repost - Thanks!
- Prev by Date: Re: Form inside a Report disapears except for the first group
- Next by Date: Re: Report must be saved for filter to work?
- Previous by thread: Re: Report Subtotals - Repost - Thanks!
- Next by thread: Acess 2000 report with multiple sum values
- Index(es):
Relevant Pages
|
