vangogh228
Registered User.
- Local time
- Today, 13:03
- Joined
- Apr 19, 2002
- Messages
- 302
Hi all.
I have been given the task to write an update query (I think) that involves billing cycles. There are two fields involved in this process: Next Bill Month and Billing Frequency. The Billing Frequency is limited to a list of three items, Monthly, Quarterly, or Annual.
What I need to accomplish is the following: The billing person queries/filters for the current month and then sends the bills based on the resulting selctions. Then, based on the Billing Frequency, the billing clerk would run an update to the Next Bill Month field that would change the entry to the correct next bill month.
I can have her filter for the current month, then filter for the frequency three separate times, updating each time manually, but I certainly would like to automate this process.
Any help would be greatly appreciated. I asked a similar question a few weeks ago regarding actual dates instead of months, but then the idea of using dates instead of months was changed (and the answer involved VB code and I did not know how to implement it). Perhaps using month names will make this easier.... at least I certainly hope so.
Thanks again for any help!!!
[This message has been edited by vangogh228 (edited 05-30-2002).]
I have been given the task to write an update query (I think) that involves billing cycles. There are two fields involved in this process: Next Bill Month and Billing Frequency. The Billing Frequency is limited to a list of three items, Monthly, Quarterly, or Annual.
What I need to accomplish is the following: The billing person queries/filters for the current month and then sends the bills based on the resulting selctions. Then, based on the Billing Frequency, the billing clerk would run an update to the Next Bill Month field that would change the entry to the correct next bill month.
I can have her filter for the current month, then filter for the frequency three separate times, updating each time manually, but I certainly would like to automate this process.
Any help would be greatly appreciated. I asked a similar question a few weeks ago regarding actual dates instead of months, but then the idea of using dates instead of months was changed (and the answer involved VB code and I did not know how to implement it). Perhaps using month names will make this easier.... at least I certainly hope so.
Thanks again for any help!!!
[This message has been edited by vangogh228 (edited 05-30-2002).]