Results 1 to 3 of 3
  1. 08-15-2013, 10:22 PM #1
    noaccessguru
    noaccessguru is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    Melbourne, Australia
    Posts
    68

    Calculated Field - No duplicates

    Hi All,

    Is it possible to make a calculated field in a table not allow duplicates?



    There is obviously no option to select No Duplicates in the field settings? so not sure if it is possible or not

    TIA
    Reply With Quote Reply With Quote
  2. 08-16-2013, 02:39 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,645
    Not possible. It's a calculation.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 08-18-2013, 10:47 PM #3
    noaccessguru
    noaccessguru is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    Melbourne, Australia
    Posts
    68
    Thanks June7....Figured that might be the case

    Thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Calculated field on a form and output to a field in a table
    By CindyJ in forum Forms
    Replies: 1
    Last Post: 04-21-2013, 03:20 PM
  2. Update a table field by a calculated field (from a query)
    By HelpMeAccess in forum Queries
    Replies: 3
    Last Post: 02-13-2013, 10:15 AM
  3. Need design suggestions for indexed-no duplicates field
    By jax1000rr in forum Database Design
    Replies: 3
    Last Post: 01-29-2013, 06:42 AM
  4. Number Duplicates with a Calculated Field in Query
    By ShocWave in forum Access
    Replies: 1
    Last Post: 11-20-2011, 12:11 PM
  5. No duplicates on composite field.
    By boundfree in forum Access
    Replies: 15
    Last Post: 09-06-2011, 02:28 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums