J
jwr
I am using Access 2003 and Windows XP Pro.
My database is sales oriented.
On my form, the following information is contained:
Order ID
Order Date
Customer ID
Payment Date
Payment $
Essett #
Essett Date
as well as much more.
My question is this. When the customer pays me, I bring the form up, and
enter the payment date and amount. Weekly, I must then forward that payment
on. I must enter one more number and date at the time of forwarding the
money. That number is called Essett (number for that particular
transmission - unique to that particular one). There may be 1 or 50 on the
transmission. The number varies depending upon payments received during the
week.
Is there a way to create a query in which I enter the "Essett" number only 1
time and Date and have it update the form that contains my payment
information? Or must I go back into that form weekly, call up each order ID
being paid, and enter the Essett number and date?
Thank you in advance.
My database is sales oriented.
On my form, the following information is contained:
Order ID
Order Date
Customer ID
Payment Date
Payment $
Essett #
Essett Date
as well as much more.
My question is this. When the customer pays me, I bring the form up, and
enter the payment date and amount. Weekly, I must then forward that payment
on. I must enter one more number and date at the time of forwarding the
money. That number is called Essett (number for that particular
transmission - unique to that particular one). There may be 1 or 50 on the
transmission. The number varies depending upon payments received during the
week.
Is there a way to create a query in which I enter the "Essett" number only 1
time and Date and have it update the form that contains my payment
information? Or must I go back into that form weekly, call up each order ID
being paid, and enter the Essett number and date?
Thank you in advance.