Access 2007 problem with update query

B BN B

Registered User.
Local time
Today, 03:08
Joined
Oct 21, 2011
Messages
32
I setup an update query for a contact hours field. In the update to field I put .5 in the criteria I placed Null because I wanted to populate .5 in all of the blank fields. Well when i ran the query it is only giving me a 0 now in the fields that were Null. I changed to decimal place to 2 on the property sheet for the contact hours field. Any ideas on what went wrong?
 
If it was changed from a text field to a number field that could explain why your nulls have been replaced by 0s.


Are they still null in the table / select query or are they always 0s now?
 
It was changed from text data type to a number data type. Now it just show 0's.
 
Then there you have it.

There are no nulls, only 0s. As such you cannot do anything to the null values, they don't exist.
 
Ok so how do i get those rows with 0s to reflect the .05 that I need? sorry the .5 that I need
 
Assuming it's all the 0s which need to be replaced just swap the "Is Null" criteria in your planned update query to 0.
 
Ok yes i was doing that when i was awaiting your response and i am still getting the 0s:(
 

Users who are viewing this thread

Back
Top Bottom