Alpha Video Training
Results 1 to 3 of 3

Thread: problems with letter in ALPHA 5 VER. NINE

  1. #1
    Member
    Real Name
    karen serrano
    Join Date
    Jan 2010
    Posts
    21

    Default problems with letter in ALPHA 5 VER. NINE

    I have a balance statement I send out every year I need the letters to be sorted by street and i dont know how the box which you put in the sort says once expression builder is used you can not change this itis spitiing out the letters by the street number not street pls help have to get statement out by the 30th on 476 of them karen

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: problems with letter in ALPHA 5 VER. NINE

    If you have one field for address and all of the entries have the format of

    number streetname anything_else

    like

    123 Elm St
    789 Poplar Ave
    456 Hwy 431

    then you can sort on

    Word(address,2)

    the sort says once expression builder is used you can not change
    That means you cannot go back to the genie after creating an expression, not that you can't change the expression.

  3. #3
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,358

    Default Re: problems with letter in ALPHA 5 VER. NINE

    This is what the Print Genie looks like with, in my case a sort on Tblservices_name.
    Print Genie.PNG
    As Stan says, if the Number and Street are in the same field, you need to use Word(address,2).
    You can always test your sort by Previewing the statements before printing.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Letter problems
    By gezzer1520 in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 04-15-2009, 05:35 AM
  2. Upgrading from Alpha ver. 2 to Alpha ver. 6
    By John Philippe P. Ortiz in forum Alpha Five Version 6
    Replies: 2
    Last Post: 06-30-2005, 10:28 PM
  3. Alpha Letter / Word Doc Problems
    By sqlpython in forum Alpha Five Version 6
    Replies: 0
    Last Post: 03-19-2005, 10:37 AM
  4. Report & Letter Problems
    By hcdoe in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-09-2003, 04:15 PM
  5. Form letter problems
    By johnhpratt in forum Alpha Five Version 4
    Replies: 5
    Last Post: 09-03-2000, 06:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •