Expression creation.

  • Thread starter Thread starter antonio
  • Start date Start date
A

antonio

This is a repost that previously showed up on the "forms"
newsgroup, but didn't get a response...Im hoping I just
picked the wrong newsgroupsection...

I am having difficulty coming up with expressions to use
for a form, query, and report that will return 12 month
totals and averages based on the current date displayed
in the current record.
Example

tblMonthReview
Review Month TotalDischrg TotalDelinq
Jan 2003 1371 241
Dec 2002 1242 270
Nov 2002 1143 225
etc.. etc.. etc..

What the requirement is to have the form display a
running total for the past 12 months based on which
record you have currently displayed. So if you are
looking at the Montly Review Record for Jan 2003, besides
January's specific numbers, you will see see a text box
that displays the average TotalDischrg Between Jan 2003
And Feb 2002. When you are looking at the record for Feb
2003, it displays the average TotalDischrg Between Feb
2003 and March 2002...and so on.

This same action needs to then be broken down into
quarterly averages...so, if you are looking at the review
record for Jan 2003, below the average of the 12 month
total there needs to be 4 text boxes that display the
following:
1st txt box)TotalDischrg Average Between Jan 03 And Nov 02
2nd txt box)TotalDischrg Average Between Oct 02 And Aug 02
3rd txt box)TotalDischrg Average Between Jul 02 And May 02
4th txt box)TotalDischrg Average Between Apr 03 And Feb 02
I just dont know how to direct the query or individual
text boxes to first go back 12 months based on the date
in the review month (which I would like the user to
specify on a parameter prompt) and then total and then
average all in one action.... I need help.
TIA
 
this posting was answered by Mr John W Vinson in the
General Discussions area of the Access News groups
(microsoft.public.access)
Thank you John.
 
Back
Top