Blank Value

  • Thread starter Thread starter Bryan Hughes
  • Start date Start date
B

Bryan Hughes

Hello,

I have a Date/Time Field in a table.

How can I change this field to a blank value if it currently has a date/time
in it, using an update query?

-TFTH
-Bryan
 
You can set the field to null. Create a new query.
Select the date/time field. When you change it to update
query, enter null in the update to: field.
 

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

#error - Blank 3
Top Ten Date Query 1
Dcount returning no results!!! 0
Multiple Date Records 6
Date Query 4
Second Post: Last Date Query 2
Query Problem 1
Soring in a Query 1

Back
Top