Results 1 to 8 of 8

student question

  1. #1
    scarlettera is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2011
    Posts
    6

    student question

    If you're asked to change a field so that it is always increased by one when a new record is added, how do you do this?

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,696
    Quote Originally Posted by scarlettera View Post
    If you're asked to change a field so that it is always increased by one when a new record is added, how do you do this?
    set it as an autonumber data type.

    any other questions?

  3. #3
    scarlettera is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2011
    Posts
    6
    And how would you do that?

  4. #4
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,696
    you should know that. If you don't know how, study the material that the teacher gave you.

    Or google it. Answers that easy should not be given away. At that point you're not learning anything.

    good luck!

  5. #5
    scarlettera is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2011
    Posts
    6
    It's not in the material and I have googled it.

  6. #6
    lkates is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Jan 2011
    Location
    Healdsburg, CA
    Posts
    3
    open the table in design view, select the field you want to increment automatically, and set the data type to Auto Number.

  7. #7
    scarlettera is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2011
    Posts
    6
    Quote Originally Posted by lkates View Post
    open the table in design view, select the field you want to increment automatically, and set the data type to Auto Number.
    Thank you so much =)

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,189
    Here's a thread that you might find helpful as well: http://www.accessforums.net/forms/ge...ber-12293.html
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Student database....kinda
    By jice89 in forum Access
    Replies: 7
    Last Post: 03-30-2011, 02:33 PM
  2. Student Information Systems
    By DrCreosote in forum Access
    Replies: 1
    Last Post: 09-29-2010, 05:33 PM
  3. Student warning system
    By spqr in forum Database Design
    Replies: 1
    Last Post: 03-17-2010, 09:45 AM
  4. Create student teams via query?
    By jmccullough in forum Programming
    Replies: 0
    Last Post: 08-19-2009, 07:21 AM
  5. Trying to create Student fixtures database, need help!!
    By jmccullough in forum Programming
    Replies: 0
    Last Post: 08-10-2009, 12:56 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
  •  
Tech Forums: Microsoft Office Forums