F
FA
Hi freinds,
I have a funtion like the following:
Public Function FindingNo(S As String, D As Date) As String
FindingNo = S & Format$(D, "dd\/mm\/yyyy")
End Function
When i pass S = ABCDE and D = 01/02/2006 it gives me
FindingNo = ABCDE01/02/2006
I want to add something to it.
For the same S and same D i want add a autonumber next to the result so
for the first record for S and D i want to see
ABCDE01/02/2006001
for the second record for the same S and D i want to see
ABCDE01/02/2006002 and so on.
S and D has a one to many relationship with Finding No so there can be
many finding no for the same S and D but i want to differentiate each
Finding No so i have to have a unique number that automatically
populate in the end or each Finding No.
Can some one help me please??
I have a funtion like the following:
Public Function FindingNo(S As String, D As Date) As String
FindingNo = S & Format$(D, "dd\/mm\/yyyy")
End Function
When i pass S = ABCDE and D = 01/02/2006 it gives me
FindingNo = ABCDE01/02/2006
I want to add something to it.
For the same S and same D i want add a autonumber next to the result so
for the first record for S and D i want to see
ABCDE01/02/2006001
for the second record for the same S and D i want to see
ABCDE01/02/2006002 and so on.
S and D has a one to many relationship with Finding No so there can be
many finding no for the same S and D but i want to differentiate each
Finding No so i have to have a unique number that automatically
populate in the end or each Finding No.
Can some one help me please??