<div>
I would correct the tables if you can, it will saves loads of grief for the future.<br />
Cheers, Andrew
</div>


I would correct the tables if you can, it will saves loads of grief for the future.
Cheers, Andrew

<div>
Thanks TW,<br />
<br />
I don't own the db TextReport so I'm not able to change DB properties.<br />
<br />
JMO9966
</div>


Thanks TW,

I don't own the db TextReport so I'm not able to change DB properties.

JMO9966

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have a PO_Detail table with an AutoNumber PK, data type Long Integer.<br />
<br />
My select statement starts with Table B and I need to join table PO_Detail.<br />
<br />
The problem is this my foreign key in table B is a Text data type instead of Long Integer.<br />
<br />
Can someone assist and show me how to cast this Text field in column B to Long Integer and also then join the two tables on this field.<br />
<br />
PO_Detail.AutoNumber=B.Col<wbr />umnName<br />
<br />
Thanks,<br />
JMO9966
</div>
</div>


Experts,

I have a PO_Detail table with an AutoNumber PK, data type Long Integer.

My select statement starts with Table B and I need to join table PO_Detail.

The problem is this my foreign key in table B is a Text data type instead of Long Integer.

Can someone assist and show me how to cast this Text field in column B to Long Integer and also then join the two tables on this field.

PO_Detail.AutoNumber=B.ColumnName

Thanks,
JMO9966

Microsoft Access query syntax help needed - need to Cast to join tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.