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

updating a field on a particular day.

P: n/a
I have information in a field (WIAStatus) If the status
is Qtr1, Qtr2, Qtr3, Qtr4, or completed. I need these
values to update to the next quarter automatically on
January 1, April 1, July 1, and Oct 1. There may be
other values in this field such as Active or dropped
which I don't want affected. I have been searching the
internet, microsoft and my reference manuals for code
samples, but so far I've had no luck.

Any Ideas how I write this particular piece of code? I'd
appreciate any and all suggestions. Macro? module? VBA?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
bf***@sctboces.org (Betsy) wrote in message news:<fd**************************@posting.google. com>...
I have information in a field (WIAStatus) If the status
is Qtr1, Qtr2, Qtr3, Qtr4, or completed. I need these
values to update to the next quarter automatically on
January 1, April 1, July 1, and Oct 1. There may be
other values in this field such as Active or dropped
which I don't want affected. I have been searching the
internet, microsoft and my reference manuals for code
samples, but so far I've had no luck.

Any Ideas how I write this particular piece of code? I'd
appreciate any and all suggestions. Macro? module? VBA?

Thanks


Try this query after making a backup of your table:

UPDATE MyTable SET WIAStatus = 'Qtr' & CStr(Val(Right([WIAStatus], 1))
MOD 4 + 1) WHERE Left([WIAStatus],3) = 'Qtr';

James A. Fortune
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.