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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
invalid cast character
- Thread starter woodJerry
- Start date
What are the Access data types that are causing your problem? Tom Davis
tdavis@sark.com
tdavis@sark.com
A cast is a programming "trick" which would allow a variable of type x to display a result of type y. They were very common in my c++ days (and probably still are for all I know but I don't work in c++ now)
For example, a cast would allow a variable of type int to display a char (or vice versa).
I can't answer your question fully because I don't yet know how (or if I am able) to use casts in SQL. There is no cast facility that I know of in Access (except perhaps to declare everthing as text). It does sound as though there is type-mismatching in one or other of your Access fields.
For example, a cast would allow a variable of type int to display a char (or vice versa).
I can't answer your question fully because I don't yet know how (or if I am able) to use casts in SQL. There is no cast facility that I know of in Access (except perhaps to declare everthing as text). It does sound as though there is type-mismatching in one or other of your Access fields.
- Status
Similar threads
- Locked
- Question
- Locked
- Question