2 fields of different lenghts

  • Thread starter Thread starter Revis01
  • Start date Start date
R

Revis01

I am creating a queary of 2 tables. Common field is Account number. Table A,
the filed is 15 characters. Table B, the field length is 25, and the 10
extract characters are zeros. How do I get the query to look at just the
first 15 characters of each feild in each table?
 
If you plan on joining then in the query then you need another query in front
with a calculated field to join on.
Expr1: Left([Your25CharField],15)
 
Create a query that looks at the first 15 characters of a field (e.g.,
Left([YourFieldName],15) from table 1.

Create a second query that looks at the first 15 characters of a field from
the second table.

Create a third query that uses the first two, joined on that 15 character
field in each.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Back
Top