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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert text to number in a query to enable join
Thank you for the reply, very much appreciated :-) I've copied your suggestion into my query grid in access so it looks like: ON CLng([CustID]) = [numeric field] and I've tried: CustID2: CLng([CustID1])=[numeric field] Neither of which work.... I've been on MS's support site to look up the...- mbnu99
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Convert text to number in a query to enable join
New to this wek site and forum but as I've been chucked in at the deep end with access I'd appreciate some help. Before I say anything more I though I'd better say I'm no SQL expert! All the tables in my DB are linked SQL ones, I have two tables in a query and need to join a text field (it...- mbnu99
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
