Here are the similarities and differences between Find and Replace and an update query: Like the Find and Replace dialog box, an update query lets you specify which value is being replaced, and what the new value is.
To use SQL view, create a blank, new query, and then switch the SQL view.
This section presents the syntax for and an example of an UPDATE statement.
Dates outside the range April 13, 1810 and September 16, 1989 exceed the size of an Integer field.
To accommodate all possible dates, set the Field Size property of your Number field to Long Integer or greater.
If the original value is in the form of a valid Internet Protocol (IP) address (four number triplets separated by a period: nnn.nnn) and the numbers happen to coincide with a Web address, the conversion results in a valid link.
Otherwise, Access appends to the beginning of each value, and the resulting links are not valid.
The dates that you can convert depend on the size of the number field.
Remember that Access stores all dates as serial dates, and it stores the date values as double-precision floating integers. Dates outside the range April 18, 1899 and September 11, 1900 exceed the size of a Byte field.
The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.
The table in this section also explains when converting a data type can change or eliminate some or all the data in a field, and what data might be eliminated.
In some cases, the conversion process might delete some data.