Results 1 to 6 of 6

Thread: ACCESS: Table Field equal another Field in the Same table

  1. #1
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,559
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default ACCESS: Table Field equal another Field in the Same table

    I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I make the default value in this field equal another field in the same table?? is there a formula I can put in the Default? Or do I need to handle this on the form with an Event? I would rather have a default value on the form if at all possible.

    Thanks!
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,388
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: ACCESS: Table Field equal another Field in the Same table

    If you have two fields in the same Table that MUST be equal to each other, what is the purpose of having two fields, instead of just that one?
    Setting up fields in a table that are dependent upon other fields in the same table violates the rules of Data Normalization, and could cause database integrity issues and undermine data integrity.

    Can you explain why you need two fields that hold the same value, instead of just having one field?
    If we understand why you are trying to do this, we may be able to make suggestions.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,559
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ACCESS: Table Field equal another Field in the Same table

    Joe;

    I am using Access to create a form that makes it easier for the user to enter data. The data is going to be uploaded to another program (Deltek CostPoint). The GUI that Deltek has is horrible. Its in Excel and the data gets entered in several different tabs. Plus I have an issue of Multiple users - which Excel is not the best at handling. Therefore I am trying to make a better GUI using Access. Why Deltek has two fields that have the same data - I don't know. All I know is that my form has to have all the same fields that the Deltek GIU has. Several of their fields have a default value of another field. Why? I have no idea and way to find out why.

    I am not using Access necessarily to store the data - its being used as GIU. I assume from your answer that the best way to handle this is on a form where the user will enter the data. I can create an event in that populates the "Duplicate" field when the first filed is changed/updated. I know it doesn't make sense to have the same data in two fields, but my task is
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  4. #4
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,388
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: ACCESS: Table Field equal another Field in the Same table

    So, are you exporting the data to Deltek, and that requires two fields with the same value?
    If so, there is no need to have the same field twice in your Table, you can add the same Table field twice in your Query (and use the Query for your export).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,559
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ACCESS: Table Field equal another Field in the Same table

    Smart! Thanks
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  6. #6
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,388
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: ACCESS: Table Field equal another Field in the Same table

    You are welcome!
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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