RE: Sum Less Than
- From: chickalina <chickalina@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 17 Jan 2007 21:12:01 -0800
To be honest with you, I am a beginner coming from an excel background and
when they asked if this type of report could be done, and I told them of
course, since it's a Microsoft Product, there must be some way to get this
done.... I'm an Access Beginner and I take help from anywhere I can get it.
I wanted to finish this report tonight, but I don't know if that can be
done. I don't know how much time this will take. All the queries are already
done. I just need to know the code to call thenecessary information for my
subreport.
"Duane Hookom" wrote:
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.
I followed your instruction about DSum and not using Sum.
Also, you are not providing any information on how this posting relates to
your first posting in this thread.
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.
- References:
- RE: Sum Less Than
- From: Duane Hookom
- RE: Sum Less Than
- Prev by Date: RE: Sum Less Than
- Next by Date: Is It Possible to Have Details Among Two Report Groupings?
- Previous by thread: RE: Sum Less Than
- Next by thread: Is It Possible to Have Details Among Two Report Groupings?
- Index(es):
Relevant Pages
|
