HEADER FIELD

M

MARGARET

hOW DO I INSERT AW ALPHABET CHARACTER INTO A TELEPHONE
LIST, WHEN SORITNG SO THAT WHEN I PRINT THE REPORT THERE
IS A HEADING E.G A - AND ALL MY CONTACTS FOR A ARE UNDER
THAT.

PLEASE HELP!!!
THKS MARGARET
 
J

Jeff Boyce

Margaret

First, please take off the Caps Lock -- ALL CAPS is considered "shouting".

Second, don't embed multiple meanings in a field. As John V. points out in
tablesdbdesign, Access is a relational database - use it relationally. A
simple query can be used to associate a name (and hence, the leftmost
character) with a phone number.

Then base your report on that query, using the alpha character to group by
in the report.
 

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

Top