MS Access, How to create variable
I would like to create a variable to set "2017/03"
I need to change following part, red rectangle part, every month.
is there a way to set one input to change "2017/03" to "2017/04"
I need to change following part, red rectangle part, every month.
is there a way to set one input to change "2017/03" to "2017/04"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
go to SQL view, copy and paste the sql statement I posted.
after that , you can also switch to design view
after that , you can also switch to design view
You really shouldn't store dates as text. Never.
/gustav
/gustav
ASKER
sorry, not sure how to input.
@Hiroyuki Tamura
1. copy the query below
Update tblHour
Set [Hour]=Replace([Hour],"201
Where Instr([Hour],"2017/03")>0
2. create a new query, go to SQL view and paste the query you copied
3. run the query
1. copy the query below
Update tblHour
Set [Hour]=Replace([Hour],"201
Where Instr([Hour],"2017/03")>0
2. create a new query, go to SQL view and paste the query you copied
3. run the query
ASKER
Thank you, Rey
somehow replace function not working.
somehow replace function not working.
saved the query you created "Query3"
do a compact and repair
run the query
view the table tblHour
do a compact and repair
run the query
view the table tblHour
ASKER
Thank you, Rey
you are right. it is working.
ASKER