Access 2 table joins

  VNAM75 11:52 27 Feb 2006

I have used table joins in Access to bring out certain records. For example I have one table listing client records (Name, address, Date, Postcode etc) and a separate, second table of postcodes. Joining the postcode fields of the 2 tables will bring out all records in the main table whose postcodes matches that of the second table.

However, what if I wanted a more advanced query join like all nottingham postcodes with a third digit "5" and ends in "E". In a query do I write: Like NG5 **E

But how do I incorporate it into a table join?

  Rand Al Thor 12:37 27 Feb 2006

If you want any post code that has a 5 AND ends in E you will need to put criteria in the post code field. Open up the query in design mode. In the criteria field for the field PostCode put this criteria.

Mid([PostCodes],3,1)="5" and Right([postcodes],1)="E"
This assumes that the postcode field is formatted the same.

  VNAM75 12:48 27 Feb 2006

Thanks I'll give that a go later.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Aardman's new YouTube channel to share the work of independent animators

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017