Thanks for the reply GingerR, I just decided to change the fields to Text, which isn't that bad since I don't need them for calculations.
Btw the data was 1, 01-16 or blank thanks though
Hello, I'm currently setting up an Access db (2000) that is linked to an Excel spreadsheet. I unfortunately am having problems when I view the table. There are two columns with “#NUM” in some of the record fields instead of numbers. I’ve checked the properties for both problem columns; one is...
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.