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.