It sounds like you need to change the data type to be either text or number. If all your keying in is the year as a 4 digit field, or if you have to have the field as a data type of date/time you'll need to key it as 01/01/1973 knowing that the 01/01 portion of the date is not used.
If someone could provide me with a sample, I can figure out the rest. I need to read from one table find the first occurence in the second table and create a third table with results and update both table 1 & 2. See brief scenario below: Thanks!!!
I have 2 tables in Access. In 1 table I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.