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]

Re: Brick Codes

Shaun previously wrote:
[color=blue]
> How can I compare the first 3 or 4 letters of the postcode[/color]

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]

Re: Brick Codes

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" <nospam@nospam. com> wrote in message
news:cMkYb.4631 $h44.733049@sto nes.force9.net. ..[color=blue]
> 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[/color]
Locations[color=blue]
> table to the corresponding entry in the Brick Codes table so I can add it[/color]
to[color=blue]
> my report?
>
> Thanks for your help
>
>[/color]