First Time User, please help with Query

[Stillgate]

I have a query with 2 tables (Table A and Table B.) My join properties between table A and B is the "Case No" column. In table A, the "Case No" column has 10 digits. All the cases end in 003. In Table B, its only a 7 digit number (it doesnt have the 003 added.)

How can I create a criteria that will remove the 003 so both tables and merge?

Table A
Case No: F123456003

Table B
Case No: F12346

[isladogs]

Use join criteria
Left([Table A].[Case No],7)=[Table B].[Case No]

Recommend you don't use spaces in table or field names.
Also if those are your real table names, replace with meaningful names.

[meisaka]

In the query of table A, you can create a new field and use this "Trimmed Case No: Left([Case No],6)"
and in a new query, match your "trimmed case No" to table B "Case No"

*Trimmed Case No" - can be any names you want to use.

hope it helps