How do I group by the first three digits of the postalcode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using office 2003xp
I would like to group names in contacts by the first three digits of the
postal code.
Can I do this?
 
fredbbi said:
I am using office 2003xp
I would like to group names in contacts by the first three digits of
the postal code.
Click to expand...

Not by the first three digits, but by the entire zip code. Add the
"Zip/Postal Code" field to the header line with the Field Chooser, then
right click and select "Group By This Field"
 
Even though it seems to be possible to group by Postal Code, I do not see
how you could group by ONLY the first three digits without using an unused
filed for those three digits and then grouping by that surrogate field.
--
Cheers,
Alphonse


I am using office 2003xp
I would like to group names in contacts by the first three digits of the
postal code.
Can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
Concatencation and formatting 17
Like and Access 3
How do you create a postal letter to a contact? 10
Contacts and Canadian Address Display 1
Nesting of groups 0
Creating fields with the same name in a Contact form 1
Stop bracketting false area code when displaying phone no 8

Back
Top