Access 2 table joins

  VNAM75 11:52 27 Feb 06

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 06

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 06

Thanks I'll give that a go later.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…