Setting destination field data types in an Access update query?

  • Thread starter Thread starter Nails
  • Start date Start date
An update query uses the datatype defined in the table's field.

If you are saying that you want to convert one data type to another and put
it into a field already set for that (second) type, you can use the
"conversion" functions in a query. Check Access HELP for CDate(), CInt(),
and so on...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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

Number of query values and destination fields are not the same. 2
query values and destination fields error 2
Update query won't work 2
Make-table Query - Destination DB question 8
Update query 2
Getting request that a query have a destination field 3
CHANGE DESTINATION FOR APPEND QUERY 2
Destination Field? 2

Back
Top