number format display without decimal

  • Thread starter Thread starter Marianne
  • Start date Start date
M

Marianne

I am trying to update a table which has a field "Hrs". The data type is
Number - double. I need to run an update query where I have a calculated
field from another table matching the "Hrs" field. When trying to update the
table I get an error message "Type mismatch in expression". How can I format
the number field in the query so that it matches the data type in the table.
 
whats the datatype of the value that you are trying to update it from
it is it string you may need to use clng() to convert it on the fly so
the value can be updated. can you show your query and tell what the
data type of the value you are trying to inser it

Regards
Kelvan
 
Back
Top