Hi,
1. Am trying to add the suffix to autonumber field, which is entered in previous field(i.e before entering Autonumber).
2. Example:
Field1: AAA, BBB
Field2(Autonumber) : AAA-001, BBB-001.
Could anybody help me with how do i do this?
Hi,
1. Am trying to add the suffix to autonumber field, which is entered in previous field(i.e before entering Autonumber).
2. Example:
Field1: AAA, BBB
Field2(Autonumber) : AAA-001, BBB-001.
Could anybody help me with how do i do this?
Can't use autonumber like this. Generating a sequence value for each Field1 value and saving to table will require VBA. Alternatively, let this sequence be calculated with textbox RunningSum property on report along with report Sorting & Grouping features.
Generating custom unique identifier is a common topic. Search Google or forum.
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.