A
anj
Dear All
Thanks in advance! I am working on a MDB database. On a field X, I need to
fill value automatically based on filter. Filter should be like this: value
should be from the same field X but from yesterday and criteria is based on
another field Y which is a combo box. So if I choose a value "VV" from COMBO
Box Y then field X should get field X's yesterday's particular value; if "ZZ"
from COMBO BOX Y then field X should get yesterday's corresponding value that
I input yesterday after choosing "ZZ" and so on. I have 9 different selection
from COMBO BOX so there are also 9 different corresponding value on field X
everyday. On the following day I want to fill yesterday's field X value in
the same field based on what value I choose from the COMBO BOX that I had
choosen yesterday.
Hope I have made my question clear enough!
It seems a bit tedious for me.
Thanks a lot!
Thanks in advance! I am working on a MDB database. On a field X, I need to
fill value automatically based on filter. Filter should be like this: value
should be from the same field X but from yesterday and criteria is based on
another field Y which is a combo box. So if I choose a value "VV" from COMBO
Box Y then field X should get field X's yesterday's particular value; if "ZZ"
from COMBO BOX Y then field X should get yesterday's corresponding value that
I input yesterday after choosing "ZZ" and so on. I have 9 different selection
from COMBO BOX so there are also 9 different corresponding value on field X
everyday. On the following day I want to fill yesterday's field X value in
the same field based on what value I choose from the COMBO BOX that I had
choosen yesterday.
Hope I have made my question clear enough!
It seems a bit tedious for me.
Thanks a lot!