Results 1 to 2 of 2
  1. #1
    BigBrownBear is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2010

    Question Populate one field based upon another fields data

    My table / query contains various fields including customer account numbers. I need to populate a new field (Sales Group) with a description that identifies a group of account numbers. E.g.:-
    Accounts 34,76,88,93 equals Sales Group “USA Parent Customers”
    Accounts 45,22,76,43 equals Sales Group “USA Non Parent Customers”
    Accounts 89,54,23,66 equals Sales Group “UK Customers”

    Any other account not listed above equals Sales Group “ROW” (Rest Of The World)
    I’m sure I’ve done this before using an ‘if’ and ‘move’ statement, but I’ve not touched access for over a year and I’ve forgotten so much. Any ideas appreciated!

  2. #2
    Gerry is offline Rusty Developer
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Kings Mountain, NC
    I'm going to make some assumptions- I didn't find your explanation very clear, but that's probably me.

    I'll assume you have a bunch of records, each including the field "Acccount Number". And the value in this field could be any of the 2-digit numbers you listed. I'll further assume that what you're trying to do is assign the Sales Group, based upon that number.

    If you create a Sales Group table, listing the each account number and the associated group (excluding the ROW), you can then use that for an update query (if you even want to store that information in the record, at all). A second update query, set to identify un-matched records, can easily add ROW to the remaining entries.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-25-2010, 09:03 AM
  2. Autofill form fields based on another field
    By ljs1277 in forum Access
    Replies: 3
    Last Post: 02-16-2010, 02:51 PM
  3. Replies: 3
    Last Post: 10-05-2009, 07:22 AM
  4. Replies: 0
    Last Post: 06-03-2009, 10:25 PM
  5. Replies: 1
    Last Post: 10-26-2007, 07:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums