smtazulislam
Member
- Local time
- Today, 22:08
- Joined
- Mar 27, 2020
- Messages
- 806
Hello,
I have a table like:
Data - DataType
VSID : PK
VSNumbers: Numbers
Name : Short Text
Date : Date/Time
Ref : Short Text
I want to create a Ref Number which Format is Like : Manual Insert "VS" / " [Name] field First 3 Digits " / "[Date] Format([Date],"yyyymmdd") " / "Day Start Record = 01"
E.G.
1) Result LIKE : VS/App/20210425/01
2) Result LIKE : VS/Org/20210425/02
3) Result LIKE : VS/Ban/20210425/03
Last Record Entry : 23:59:59
Then Next Day:
1) Result LIKE : VS/Pea/20210426/01
2) Result LIKE : VS/Ban/20210426/02
3) Result LIKE : VS/Bla/20210426/03
I have a table like:
Data - DataType
VSID : PK
VSNumbers: Numbers
Name : Short Text
Date : Date/Time
Ref : Short Text
I want to create a Ref Number which Format is Like : Manual Insert "VS" / " [Name] field First 3 Digits " / "[Date]
E.G.
1) Result LIKE : VS/App/20210425/01
2) Result LIKE : VS/Org/20210425/02
3) Result LIKE : VS/Ban/20210425/03
Last Record Entry : 23:59:59
Then Next Day:
1) Result LIKE : VS/Pea/20210426/01
2) Result LIKE : VS/Ban/20210426/02
3) Result LIKE : VS/Bla/20210426/03