Sorting problem in a Table

[Dave Smith]

Hi all,

I have a problem, I am helping out a non profit group. They are using
Access ver 2002. They have a membership table with address info in it. We
are in Canada so the Postal Code is in the form of K8N 3H2. All other
fields sort fine. With Postal Code when it is sorted there will be two
blocks of sorts, both are in order. But all the K8N 3H2 entries for
instance will be in two groupes and this is a pain for doing mailings. The
field property is >L0L 0L0. I have tried copying and pasting data from one
correct field to the incorrect entries but that did not work. If we sort by
City all the postal codes come together. I am at a loss. Hope someone can
suggest something.

I should mention using a Query does not help. The data is still in two
groups. The problem rests with the Table.

Dave

 

[Rick Brandt]

Hi all,

I have a problem, I am helping out a non profit group. They are using
Access ver 2002. They have a membership table with address info in
it. We are in Canada so the Postal Code is in the form of K8N 3H2. All other
fields sort fine. With Postal Code when it is sorted there
will be two blocks of sorts, both are in order. But all the K8N 3H2
entries for instance will be in two groupes and this is a pain for
doing mailings. The field property is >L0L 0L0. I have tried
copying and pasting data from one correct field to the incorrect
entries but that did not work. If we sort by City all the postal
codes come together. I am at a loss. Hope someone can suggest
something.
I should mention using a Query does not help. The data is still in
two groups. The problem rests with the Table.

Dave

Are you positive that the two groups really have the *same* entry? No leading
spaces? No extra spaces?

 

[Dave Smith]

Hi Rick,

The field property of >L0L 0L0 should block out mistakes such as on O and an
0. Also I did copy and paste from one block to the other block so if there
were any differences they should have been wiped out.

Dave

 

[Rick Brandt]

Hi Rick,

The field property of >L0L 0L0 should block out mistakes such as on O and an
0. Also I did copy and paste from one block to the other block so if there
were any differences they should have been wiped out.

Can you post a representative sample of how the sorting is currently working?