+ Reply to Thread
Results 1 to 3 of 3

Avoiding Duplicate Combinations in Access 2007

  1. #1
    Registered User
    Join Date
    06-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Avoiding Duplicate Combinations in Access 2007

    Hi,

    I'd just begun to gain confidence in SQL, when I came across this issue:

    I am creating a Table using SQL in Access 2007.
    In this table, I want to create a field called ID for student records (Integer data type). I want to create another field called "Months" (INTEGER data type), and want to limit it to values between 1 and 12. Now, since student records would also begin with 1, I am in a fix when the two fields have duplicate combinations.

    Any help on this will be much appreciated.

    Thanks in Advance.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Avoiding Duplicate Combinations in Access 2007

    Why are you in a fix?

    They are different fields.

    PS Have you looked at using an AutoNumber field for the ID?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: Avoiding Duplicate Combinations in Access 2007

    Thanks Norie.. Maybe I was thinking too much about avoiding duplicates..

    And yes, I have looked into the AutoNumber option for ID.

    Thanks very much for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1