Access 2003 – adding values to a specific record via a query

5 pts.
Tags:
Access 2003
Database programming
Microsoft Access
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter yes or no. Now customers will input deposits of money. i want to find a way where a query will automatically append "yes" to the "Paid?" field whenever the total value of deposits cover each payment. to clarify: date value Paid? 10 10000 20 5000 30 5000 40 5000 50 15000 for example if the total deposits the customers paid to buy the appartment is 20000 i want the query to append "yes" to the 3rd row since at that row 20000 has been paid. however if 14999 has been the total deposit by the customers then till only the second row where the "Paid?" field "yes". if its possible, i would also would want a way to find how much money is needed to pay the next payment. i have no problem using a very different way .any help would be appreciated
ASKED: July 24, 2008  11:45 AM
UPDATED: July 24, 2008  12:08 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following