October 20, 2004 at 10:26 am
Hi,
i need use this join
35 = 0000035 ---> 35=35
how can do it? Number of 0 is diferent. I cannot use right, or convert.
thanks zd
October 20, 2004 at 12:02 pm
Have you tried CDbl([Field1]) = CDbl([Field2])?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
October 21, 2004 at 6:32 am
May I ask why you cannot use any casting?... because if you can't do it in sql you're gonna have to do it on the client side... and I can't see that hapenning nearly as fast as sql server can do it.
October 21, 2004 at 1:53 pm
Since this is MS Access, you need to do the following:
Create a query for the table with the field with 000000035 in it.
Create a User Defined field: NewKey: CLng([OldKey]) This will conver it to a long datatype.
Create a new query using the query above and the table where it is defined as 35.
*** CLng should be changed to match whatever datatype the valuse in the second table is.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply