Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change name order (A2K SR1)

    I need to print out the time cards for a large organization. One of the sections, the largest, sent the Name field as First (space) Last and I need to print them as Last (,) First, of course. There are over 500 names and I am not able to get then all retyped in time. Is there a way to move the files as I need them easily and quickly.

    The staff, who would like to be paid on time, and I thank You in advance.

    Is there any good books on how to program in VBL available, I used to do fairly well in dBase but that was a long time ago.

    Bob

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Change name order (A2K SR1)

    In Access Reports, the sort order is controlled by the Sorting and Grouping option. While in design mode for that report, there is a Sorting and Grouping button on the toolbar, or from the main Menu Bar, select "View" | "Sorting and Grouping".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change name order (A2K SR1)

    If this is a 'one-off' it would probably be quicker to copy the data out to Excel and use the 'Text to Columns' wizard to parse out the names. Then copy back to Access. IMHO
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Change name order (A2K SR1)

    Hi Bob,
    Do you mean that the first and last name are in one field, they're just the wrong way round for your purposes?
    If so, you can retrieve them the way you want in a query using something like:
    Name: Mid([Field1],InStr([field1]," ")+1) & ", " & Left([Field1],InStr([Field1]," ")-1)
    where Field1 is the name of your Name field. You can either do this in the source query for your report, or use it in an update query to amend the original data. Note that I've assumed you never have more than 2 names (i.e. no middle names, no suffixes).
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    Apr 2001
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change name order (A2K SR1)

    Thank You, I did try it and it worked.

Posting Permissions

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