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
1  1717 
"Paul Mendez" <pm*****@thelyn dco.com> wrote in message
news:99******** *************** ***@posting.goo gle.com... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: lawrence |
last post by:
I've been bad about documentation so far but I'm going to try to be
better. I've mostly worked alone so I'm the only one, so far, who's
suffered from my bad habits. But I'd like other programmers to have an
easier time understanding what I do. Therefore this weekend I'm going
to spend 3 days just writing comments. Before I do it, I thought I'd
ask other programmers what information they find useful.
Below is a typical class I've...
|
by: ti33m |
last post by:
Hi All,
I'd like to include a datasheet on my user interface but since I'm
starting to run tight on space, I'd like to have a vertically-oriented
datasheet (column 1 has labels, column 2 has values), i.e. a
transposed datasheet or datasheet in column format. A vertical
datasheet will look cleaner, eliminate the need to scroll across (for
miles) and lay out bit more efficiently since I have some long labels.
It seems like Access only...
|
by: pw |
last post by:
Hi,
I am having a mental block trying to figure out how to code this.
Two tables:
"tblQuestions" (fields = quesnum, questype, question)
"tblAnswers" (fields = clientnum, quesnum, questype, answer)
They are related by quesnum and questype. There are records in
|
by: Mark |
last post by:
Hi All,
Access 2002 using Windows XP
I am pretty new to writing code so please bear with me. I have some code
which exectues an append and a select query. Both queries require the user
to enter a date. Becaue of this, the same information has to be entered
twice which I would like to avoid.
Is there a way using code, that I can prompt the user to enter the date and
|
by: pemo |
last post by:
Is C really portable? And, apologies, but this is possibly a little OT?
In c.l.c we often see 'not portable' comments, but I wonder just how
portable C apps really are.
I don't write portable C code - *not only* because, in a 'C sense', I
| | |
by: L. R. Du Broff |
last post by:
I own a small business. Need to track a few hundred pieces of rental
equipment that can be in any of a few dozen locations. I'm an old-time C
language programmer (UNIX environment). If the only tool you know how to
use is a hammer, every problem tends to look like a nail. That said, I
could solve my problem in C, but it's not the right tool. I need to come
into the Windows world, and I need to get this done in Access or
something...
|
by: javelin |
last post by:
I know, that statement can make me lots of enemies. I am sorry, but
I've worked with a SQL Server back end with an MS Access ADP on the
front end, and the process of creating queries, and especially update,
insert and delete queries is SO much easier in Access. I didn't think
I'd miss it when I moved over to an environment managing about 160
"nearly identical" databases across several servers. I was wrong.
I suppose I can create a front...
|
by: Takeadoe |
last post by:
Dear NG,
Can someone assist me with writing the little code that is needed to
run an update table query each time the database is opened? From what
I've been able to glean from this group, the Autoexec Macro looks like
the way to go. Could someone please assist?
Thank you very much!
Mike
|
by: Merdina |
last post by:
In the interest of full disclosure, I must admit that this is the first time I have ever tried using Access, let alone worked with VB. I came up with an idea for an access database that will help me keep track of allowed and used vacation/personal time much easier and with fewer errors than doing it manually, as I have been.
I am trying to switch from a text box that pulls from a table created by a query to one that automatically calculates...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
