MS ACCESS Filters

[Guest]

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!!

 

[Joseph Meehan]

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!!

I don't understand the British postal codes and I doubt if many others
here do either. Maybe if you provided some additional explanation about how
they work and exactly what you want along with same samples, maybe we would
have a better idea.

 

[Guest]

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!

 

[Joseph Meehan]

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!

I often have a hard time visualizing these things so let me just pass
out a couple of ideas.

The Left([FILENAME],1) will give you the first letter of the filed
FILENAME. You could get the first two letters by changing the 1 to a 2.

Access has a count and group capabilities. I would think you can
accomplish what you want with these features in a Query.