Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alec77
Starting Member
5 Posts |
 Posted - 2003-01-15 : 10:46:30
|
| I have 3 controls in a table: date, status, future date. I want, for every month, "future date" is updated to the following month when date is more then the 21th of every month and when status is equal to 70%. Example: Date=22/01/2002 Status=70% Future Date--> February Thank you! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-01-16 : 08:17:51
|
What do you want for "FutureDate" if that condition is not true? Which day of the month do you want for Future date? Or, is it just a string that is the name of the next month?Also, try reading Access HELP about the following functions:IIF()DateSerial()Month()Day()the AND operatorNext, I am confused:quote:
I have 3 controls in a table: date, status, future date.
Either the word "control" should be "field", or the word "Table" should be "Form" ... not sure which ....Finally, if it is a table, do you need to UPDATE a field in the table? Are you querying that table and would like to include an extra column based on the formula given? are you adding records from one table to another?- Jeff |
 |
|
|
|
|
|
simple sql code