By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Brick Codes

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.