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

    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
    Ottawa, Ontario, Canada; West Palm Beach FL
    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.

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