Brick Codes

[Shaun]

Hi,

I have a table of Locations around the country. My system produces reports
based on these Locations. I also have a table containing Brick Codes e.g.

Brick Post Code
AB51 AB51
AB52 AB52
AB55 AB55
AB56 AB56
AL01 AL1
AL02 AL2
AL03 AL3
AL04 AL4
How can I compare the first 3 or 4 letters of the postcode in the Locations
table to the corresponding entry in the Brick Codes table so I can add it to
my report?

Thanks for your help

[Peter Russell]

Shaun previously wrote:

How can I compare the first 3 or 4 letters of the postcode

Do you mean (a) you want to compare the full postcode entries on each
table, or do you mean (b) you only want to compare the first 3 or 4 chars
of fields which might contain more than that.
If its (b) then are you comparing up to the first space character?

Peter Russell

[Larry Linson]

Join those fields (which may be calculated fields to extract only the data
you want from the stored field data) in a query, and drag the Brick Code
down into the Query Grid in Query Builder Design View.

If the examples are both representative and extensive, you might be able to
accomplish a similar result by calculation/manipulation of the post code.
But, it is likely better to use the first approach, because it should work
even if the same pattern is not maintained.

Larry Linson
Microsoft Access MVP

"Shaun" <no****@nospam.com> wrote in message
news:cM*******************@stones.force9.net...

Hi,

I have a table of Locations around the country. My system produces reports
based on these Locations. I also have a table containing Brick Codes e.g.

Brick Post Code
AB51 AB51
AB52 AB52
AB55 AB55
AB56 AB56
AL01 AL1
AL02 AL2
AL03 AL3
AL04 AL4
How can I compare the first 3 or 4 letters of the postcode in the Locations table to the corresponding entry in the Brick Codes table so I can add it to my report?

Thanks for your help