update query base on condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to update my record with current date time, if the value is null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,
 
Souris said:
I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,
Click to expand...
 
Souris said:
I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,
Click to expand...
 
Souris said:
I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,
Click to expand...
 
Souris said:
I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,
Click to expand...
 
You must log in or register to reply here.

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

FieldValues in relative number sequence? 5
Sum 4 Fields with conditions 4
Access Determine what query to run based on a checkbox 0
Update Query Without Replacing Text 3
Stored date is not being recognised 1
Subtraction of values from 2 records of the same field 5
Error: Compile Error,ByRef argument type mismatch 0
Database Import Duplicate Issue 0

Back
Top