Sql updating a table with values from another table
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.
To use SQL view, create a blank, new query, and then switch the SQL view.
This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. Our requirement is that we have Table2 which has two rows where Col1 is 21 and 31.
Values must not exceed (or fall below) the size limit set for the field.
For example, you can convert a Currency field to an Integer field only when those values are greater than 255 and do not exceed 32,767. Access tries to convert other values, meaning that you see underlined text, and the cursor changes when you point at the link, but the links don't work.
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.