I have created an Access append query that extracts data from an external database (ODBC connection to Sybase database). The table to which I want to append the records has a Y/N field for which I have written a data validation rule to accept text values of Y or N from a six-position text field in the extracted data file, but Access won't let me do it. I get a type conversion failure message when I try. Is it possible to do this? If so, can you point me in the right direction? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Append Query/Field Validation Issue
- Thread starter Steck
- Start date
jimmythegeek
Programmer
If I understand your question right, then at least part of the problem is that a yes/no field cannot accept a "Y" or "N". It has to either be true (-1) or false (0) (-1 / 0 recommended). <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Status
Similar threads
- Locked
- Question
- Locked
- Question