Results 1 to 2 of 2
  1. #1
    ankash is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2011
    Posts
    3

    Setting Reference Number for records

    So far I have created a table and a form that is used by 6 users. I would like to setup a reference number for each record for each user on each date.

    For example:
    User A has 3 records today, then I will have A1, A2, A3 on 12July.



    I have tried to use 1 + DCount("[Reference No]", "Database", "[IA] = i_IA and [Date] = i_Date ")

    However, when I add a new record, the reference number remains the same (e.g. it does not keep updating)

    How can I have the reference number keep updated?

    Many thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please explain what you mean by reference number and what its purpose would be.

    Are you thinking of a Primary Key (PK) which uniquely identifies each record in a table?
    You may wish to research Autonumber in MSAccess.
    see http://www.bluemoosetech.com/microso...Primary%20Keys

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

Similar Threads

  1. Auto generate reference number
    By JonB1 in forum Import/Export Data
    Replies: 1
    Last Post: 02-19-2011, 06:38 AM
  2. The number of records in a query
    By Persist in forum Programming
    Replies: 3
    Last Post: 07-13-2010, 06:23 AM
  3. Number of Records Found by a Query?
    By Xiaoding in forum Queries
    Replies: 3
    Last Post: 03-05-2010, 03:34 PM
  4. Replies: 5
    Last Post: 10-08-2009, 05:15 AM
  5. Correspondence Reference Number Generation
    By ildanach in forum Forms
    Replies: 1
    Last Post: 04-28-2009, 12:09 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
  •  
Other Forums: Microsoft Office Forums