By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,293 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,293 IT Pros & Developers. It's quick & easy.

really need some help writing some code in an access query

P: n/a
I really need your assistance. I tried what you gave me and it did
not work and I am thinking that the formatting that showed up when u
saw my posting might have confused you. So I made sure to align it
correctly this time. Ok... this is what I want it to get done. Where
the X and Y are, I need to have showing is the values, $250.00 and
$216.00, respectively. What it needs to do is... go back two months
from the current date that they are in and post the value from the
Cur_MthEnd_bal column (from two months ago of course)... in the
Bal_Fwd cell. In other words, it is calling the Cur_MthEnd_bal from
two months ago and placing it in the Bal_Fwd cell.

Date Code Bal_Fwd Fees Amt_Coll Cur_MthEnd_bal
1/15/2004 KW $0.00 $500.00 $250.00 $250.00
2/15/2004 KW $0.00 $300.00 $500.00 ($200.00)
3/15/2004 KW X $123.00 $584.00 ($461.00)
1/15/2004 SO $0.00 $466.00 $250.00 $216.00
2/15/2004 SO $0.00 $300.00 $500.00 ($200.00)
3/15/2004 SO Y $123.00 $584.00 ($461.00)

Notes: The Fees and Amt_Coll are stored in a table. The
Cur_MthEnd_Bal is a calculation (Bal_Fwd+Fees-Amt_Coll). The Bal_Fwd
entries that have a zero is because there is no record showing from
two months before. So when I finally get this working, it will
automatically place zeros there. The query that is showing this is
titled qryAR and the table that is storing the stored values this is
MainAR.

If you need anymore information, please let me know
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Paul Mendez" <pm*****@thelyndco.com> wrote in message
news:99**************************@posting.google.c om...
I really need your assistance. I tried what you gave me and it did
not work and I am thinking that the formatting that showed up when u
saw my posting might have confused you. The query that is showing this is titled qryAR and the table that is storing the stored values this is
MainAR.


please post the sql code for the query qryAR
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.