cast access text to numeric

T

TheBellonz

Joined
Aug 19, 2014
Messages
2
Reaction score
0
I'm working in access 2007. I have a couples of tables that I've imported from Excel in the link mode, so access makes a copy of them and I can use them just in read mode. Now I'm in a trouble with a cast. The primary key is text in the first table and integer in the other one. I want to make the first one like a numeric field.

I assume the left table like "Lansweeper_jacopoBelloni" and as the right table "PC_CarelHQ_modificato". I have to do 3 queries, one with a inner join because there must be a (1,1) relation beetween the two tables. A right join to check what there is in the left table that there is also in the right one. Finally I have to do a left join to find what in the right table is also in the left one. Thanks in advance
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid use of null value error Access 2007 0
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Access 2010 query for 3 tables 0
Access stripping decimal places in query 1
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Payment Dates in Access 2007 0
linked table queries 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top