banavas
03-17-2005, 01:30 AM
Dear Friends,
I want to write a piece of code (VBA) that updates the values of a table that are located between the dateA and dateB.
To update the whole table I use the following:
LFactor = 3
LUpdate = "update [plhresTable]"
LUpdate = LUpdate & " set [PraxiOgkos] = [PraxiOgkos]*" & LFactor
db.Execute LUpdate, dbFailOnError
How can I apply the above action between dates dateA and dateB?
Thanks in advance,
G.
I want to write a piece of code (VBA) that updates the values of a table that are located between the dateA and dateB.
To update the whole table I use the following:
LFactor = 3
LUpdate = "update [plhresTable]"
LUpdate = LUpdate & " set [PraxiOgkos] = [PraxiOgkos]*" & LFactor
db.Execute LUpdate, dbFailOnError
How can I apply the above action between dates dateA and dateB?
Thanks in advance,
G.