邮政编码信件计数查询 [英] Postcode Letters count query

问题描述

我必须创建一个查询，通过邮政编码大于100的邮政编码的第一个字母产生一个计数。（在Bitish邮政编码中）


For例如

邮政编码的第一封信件数

B 300

CM 260

CR 237

CV 288

NOT

B1 200

B2 150

CM 260


任何帮助都将不胜感激。


谢谢


Addy

I have to to create a query that produces a count by the first letter(s) of the postcode where the count is greater than 100. (In Bitish postcodes)

For e.g.
First Letter(s) of Post code Count
B 300
CM 260
CR 237
CV 288

NOT
B1 200
B2 150
CM 260

Any help would be appreciated.

Thanks

Addy

推荐答案

我不知道英国的邮政编码所以你必须在这里帮助我。

你需要做的第一件事是分开来自数字的字母，然后进行计数。邮政编码中可以有多少个字母？

I don''t know British postal codes so you''ll have to help me out here.
First thing you need to do is seperate the letters from the numbers and then do the count. How many letters can there be in the postal code?

字母和数字之间总是有空格吗？

And are there always spaces between letters and numbers?

我终于决定只看这样......

Well I finally decided to just look it up so...

展开 | 选择 | Wrap | 行号

这篇关于邮政编码信件计数查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！