CInt和Val职能 [英] CInt and Val Functions

问题描述

您好......我是开发和编码的新手。我必须连接两个表...表A有列System_No（即1），在表B中我试图从一个字段中获取System_No，该字段将数据保存在文本字段中（即1-CAN）。  我想在MS Access 2010
中使用Parse从文本字段中获取System_no并创建连接没问题。  然而在2016年，Parse功能似乎不起作用。  

Hello... I am new to developing and coding. I have to join two tables... Table A has column System_No (ie 1), and in Table B I am trying to get the System_No from a field that holds the data in a text field (ie 1-CAN).  I want in the MS Access 2010 I used Parse to get the System_no from the text field and created the join no problem.  However in 2016, the Parse function does not seem to work.  

我试过VAL（），这似乎给了我正确的信息，我尝试了CInt（Instr（表B.Text），1），数据看起来很好第一个查询，但是当我尝试使用表A加入查询时，我收到数据不匹配错误。

I have tried VAL() which seems to give me the correct info and I have tried CInt(Instr(Table B.Text),1) and the data looks good in the first query, however when I try to Join the query with TABLE A, I get an Data Mismatch error.

有没有人知道替代2016年的PARSE函数？

Does anyone know a replacement for the PARSE function that works with 2016??

谢谢，

妮可

推荐答案

嗨妮可，我可能是错了，但我不知道Access中的PARSE功能。您确定它不是您需要从旧数据库导入的自定义功能吗？只是我的2美分......

Hi Nicole, I could be wrong but I am not aware of a PARSE function in Access. Are you sure it's not a custom function you need to import from your old database? Just my 2 cents...

这篇关于CInt和Val职能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！