How to display only 3 letters of a last name in field

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a muni court on Access 2003. Judge wants me to print out a list of all
"outstanding balances due" so that any of the other personnel can take a
payment from a defendant when I'm out of the office. I created a query that
works fine but with underage defendants, I have to protect their identities
and many times these are old fines and defendants don't know how much they
owe or what their case number was. So, can I reduce the amount of letters (to
3) in my 'last name' field that prints out on my query, form or report -
without messing up their last name in the table? Thus protecting a juvenile
but giving enough info for a town employee to look up what they owe... This
is my first post and I've only been on the job one year. Thank you in
advance!
Judy
.

Relevant Pages

  • Re: How to display only 3 letters of a last name in field
    ... works fine but with underage defendants, I have to protect their identities ... but giving enough info for a town employee to look up what they owe... ... This will of course show Mr. Jones, Ms. Jones, Mr. Jonathan, the other Mr. ... Jonathan as JON... ...
    (microsoft.public.access.queries)
  • Re: payment into court query
    ... The details are important if you want any opinions as to whether their ... offer is likely to protect them. ... Has the OP posted more details about his dispute ... with the defendants somewhere else? ...
    (uk.legal)