Access Microsot Access 2013 update query

A

amalhakim90

Joined
May 5, 2015
Messages
2
Reaction score
0
hi guys,
can someone assist me on how to update the data based on dates.
i created table inventory return which consist item,start date , end date , rental term and status.Basically, the thing that i want to do is, the status column will changed into "YR1" when the start date has already complete its 1 year and "YR2" for 2 year while it will refer to the current date "date()". So, i try to use the query by "update into", but its not working.
Any idea for my problem? :(:(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Date Parameter Query 0
Excel MS Excel "IF" Logic Help Needed 1
Access Access Eliminate Blank Query Results 1
Microsoft reportedly planning Windows 9 release in April 2015 11
Access Access 2007 - Using Cascading Combo Boxes to Filter a Query 0
Comparing records by year in a report 2
update query 4
Today's Date in Update Query 10

Top