H
holdings
Allow me to explain what I'm trying to do(rookie here so be kind
I'm trying to create this for my mother-in-law.
Using Access 2003. I've created a simple DB. 1 Table, couple of forms
(This is almost like an inventory style Database)
Lets say when I enter info on form1 to add a new item, in the
"status" field I enter "New Today" (enter todays date on form as well).
I do this maybe 15 times for the new items that came in today. Say I
may have entered 5 items yesterday the same way,In a list box I have on
form2, I'd like an update query to run basically everytime I open the
DB to change the "status" field in my table from "New Today" to "Old"
based on todays date.(i.e If "date" doesnt = todays date, change the
status to "Old".
So if anyone is still following me, how would I go about running the
update query? I've made one but everytime I run it it updates
everything including todays date?
Thanks
Daryl
I'm trying to create this for my mother-in-law.
Using Access 2003. I've created a simple DB. 1 Table, couple of forms
(This is almost like an inventory style Database)
Lets say when I enter info on form1 to add a new item, in the
"status" field I enter "New Today" (enter todays date on form as well).
I do this maybe 15 times for the new items that came in today. Say I
may have entered 5 items yesterday the same way,In a list box I have on
form2, I'd like an update query to run basically everytime I open the
DB to change the "status" field in my table from "New Today" to "Old"
based on todays date.(i.e If "date" doesnt = todays date, change the
status to "Old".
So if anyone is still following me, how would I go about running the
update query? I've made one but everytime I run it it updates
everything including todays date?
Thanks
Daryl