MS ACCESS Filters

G

George

kHey guys...this is scenario...i have a list of first letters (B, EH, G,
LE...) all of whcih are the codes that start of postal sectors for cities in
the UK. I have two long lists of postal codes. What i need to do is find out
how many 'lines' (a post code to b post code) start with one of the city
letters and end with either the same (so inner city) or any of the others
(intra city).....at the moment i am using advanced filter and just swapping
them around so taking along time for each one....someone said something abotu
crosstab filttering but not sure how to do this....if any of this makes sense
(i realise my explanation not great!) would really appreciate some help,
thans!!
 
G

George

ok...is very hard to explain! forget about the post codes...not really
important. what i have is a database with three columns. First two columns
are lists of text codes and the third is a list of bandwidths. There are
about 10 badnwidths and 1000 pair of codes so for example codes that are 10M
may number about 100 and as such can be grouped. Then, sepratley, i have a
table which gives me a list of the start of the codes that are important to
me. For example B, so any codes starting with B are important, but any
starting with C, are not. So what i need is, within a group of same
bandwidths, is to find out how many in column A starting with say 'B' either
match with codes in column B staerting with 'B' and also any starting with
any other starts to the code found in the table.

This is very complicated and although i sure not computerwise but to explain
is hard. I better just get down to it really but if u can decipher this would
be great if u could lend a hand, thanks! ask for any more clarifcation but if
totally lost just leave me to it!
 
Top