title: Error "Can't update all the records in update query; didn't update 9 field(s) due to type conversion failure" Dcount Update Query
body: <p>I know how completely wrong it is to store calculated data in a table! But, in this case it is very necessary for what I need.</p>
  
  <p>I am using this statement:</p>
  
  <pre>
  UPDATE BusinessStreets
  SET BusinessesPerStreet
  = DCount("*","Businesses","StreetName='" & Replace(StreetName,"'","''") & "'");
  </pre>
  
  <p>It goes to update the correct records in the table by asking if I am sure I want to continue as this cannot be undone, but then gives me an error:</p>
  
  <pre>
  Microsoft Office Access can't update all the records in the update query.
  Microsoft Office Access didn't update 9 field(s) due to a type conversion failure
  </pre>
  
  <p>When it says "field(s)" I am sure it means records as I have 9 records in this table at the moment, which once I have this working, I will then increase to over 100.</p>
  
  <p>The field which will be updated is a Long Integer field, which should be fine as the Dcount function will yield numeric results.</p>
  
  <p>What is the problem with this statement?</p>
  
  <p>Thank you for giving me your time to help me with this. It's really really appreciated!!</p>