RE: Sum Less Than

Create a query(s) that calculates your previous quarter ending balance(s).
Use these as the record source for a subreport.

There are probably many ways to do this. Every suggestion I have made in
previous threads seem to have been ignored or abandoned by you. I'm not sure
why you insist on going off on tangents that lead nowhere.
--
Duane Hookom
Microsoft Access MVP


"chickalina" wrote:



"Duane Hookom" wrote:

I'm am wondering why you think your expression would work. Did you check help
on DSum() or look at any examples of its usage?

When you ask a question like this, you should tell us something about where
you are using this, what is [CurrTot], and what is "q-yy".

I copied that expression from someone else...
I am using this in a report...
There are two fields that I want to have previous quarter ending balances for
TotTax and TotInt
"q-yy" is the format for the user to just enter the quarter and year 4-06,
for the report to make it as simple as possible.

Also, you are not providing any information on how this posting relates to
your first posting in this thread.
I followed your instruction about DSum and not using Sum.

Also, does this have anything to do with the thread you began earlier
"Report question for Duane" that you didn't reply to my last posting?

It's the same thing, I'm trying a different approach now. My Database is
due tomorrow and I thought this was an easier solution.

Is there any way to get the previous quarter ending balance?


--
Duane Hookom
Microsoft Access MVP


"chickalina" wrote:

How come this doesn't work?

=DSum([CurrTot]-1,"q-yy")

I'm getting an error message....

"chickalina" wrote:

Does anyone know the formula (either in the query or the report) that would
sum all the fields less than the date chosen?

I have a report where the user selects a quarter to view... All the fields
with activity in that quarter appear on the report, the totals show, it's
great. I am now trying to get a sum for all the transaction prior to that
quarter... for instance.... If the user chooses to view 4-06, then I need a
total for everything up to and including 3-06 OR ( I know this is not correct)

=Sum (<[date]) which literally means sum up all transactions prior to [date]

I hope this makes sense.

Thanks.
.

Relevant Pages

  • RE: Crosstab query dynamic columns ala Duane Hookom
    ... "javablood" wrote: ... I was trying to sum in the footer. ... "Duane Hookom" wrote: ... not too worried about getting this aspect of the report to work because I ...
    (microsoft.public.access.reports)
  • Re: Found a big mistake...still need your help!
    ... and get a sum of 26:30 which is 26 hr and 30 minutes ... "Duane Hookom" wrote: ... "Tom Ellison" wrote: ... I generated a report, The Associate ID being the one and only ...
    (microsoft.public.access.reports)
  • RE: Crosstab query dynamic columns ala Duane Hookom
    ... I was trying to sum in the footer. ... "Duane Hookom" wrote: ... "javablood" wrote: ... will explain the empty space in the report footer. ...
    (microsoft.public.access.reports)
  • RE: calculations in report controls
    ... number to a string. ... "Duane Hookom" wrote: ... In the control source of a text box in the report footer, ... number of days should sum and count only those records less ...
    (microsoft.public.access.reports)
  • RE: calculations in report controls
    ... "Duane Hookom" wrote: ... In the control source of a text box in the report footer, ... number of days should sum and count only those records less ... count of negative one (there is only one instance so far with a missing date). ...
    (microsoft.public.access.reports)
Loading