Re: Year-to-date Totals

Joe,
I want to know how to write the calculation for getting the Weekly and YTD
total that will reset to zero next year.
My query looks like this:
qryPayeeInfoTotals: query name
PayeeNum Group By
PayeeDate Max
ChkNum1 Group By
ChkAmt1 Sum
ChkNum2 Group By
ChkAmt2 Sum
--
Thanks
D''''Angelia


"Joe Cilinceon" wrote:

> Ok let me see now if I understand what you are asking. You have a query that
> you want to get totals from for various time periods time. If that is true
> then use the criteria example I posted earlier for the PayeeDate, this will
> give only the Chkamt collected in that period of time. Now for the totals
> you can set up the query to group by date, payee number and chknum with a
> sum on chkamt.
>
> --
>
> Joe Cilinceon
>
>
>
> DAngelia wrote:
> > Joe,
> > What do I have to do about the YTD Total?
> > Are you saying that this criteria will reset the date field to the
> > next year?
> >
> >
> >> DAngelia wrote:
> >>> Hello,
> >>> This is my second time posting this request.
> >>> I wasn't sure if it went threw.
> >>> I have the following fields in a query.
> >>> PayeeNum
> >>> PayeeDate
> >>> ChkNum1
> >>> ChkAmt1
> >>> ChkNum2
> >>> ChkAmt2
> >>> WeeklyTotal: chkAmt1 + chkAmt2
> >>> I get a weeklytotal working okay.
> >>> I would like to get the weeklytotal and ytdtotal (for each year) and
> >>> have them reset to zero at new year.
> >>>
> >>> How? Help!
> >>>
> >>> Thanks
> >>> D''''Angelia
> >>
> >> In the criteria field under PayeeDate you could put Between
> >> DateSerial(Year(Date(), 1, 1) And Date(). I think the syntax for the
> >> DateSerial is correct. I use several queries based on Date fields in
> >> such a manner.
> >>
> >> --
> >>
> >> Joe Cilinceon
>
>
>
>
.

Relevant Pages

  • Group Records by Cumulative Value
    ... To get it into a query, ... calculate the cumulative and overtime totals in new ... name in the report exactly how you want it. ... >Joe Mon 15 ...
    (microsoft.public.access.queries)
  • Re: How Do You Order an Aggregate Function
    ... Joe, ... You should be able to create a totals query that calculates your cost of ... Then add this query to your report's record source ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... from the $'s being listed more than once in the query. ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ...
    (microsoft.public.access.reports)
  • Re: Running balance from two tables
    ... the TOTALS button and show a totals line in the query, ... my total additions and my total costs and see how much money is in my ... What I'd love to do with it is have something pop up when the balance is ...
    (microsoft.public.access.queries)
  • RE: Crosstab Worries
    ... I copied your sql into my Northwind and I created a form off that query and I ... concerned, the recordsource is three letters, Jan, Feb, but the text box is ... You can sum a field from the record source but not ... with their totals in each of the twelve columns. ...
    (microsoft.public.access.queries)