Hello all!
Here is the question!
I have a table as below, named tblRollcall, with two fields (EmployeeName and DateOfRegistry). I need to number each record based on these two different fields.
EmployeeName................DateOfRegistry
A..............................................01/01/0001
A..............................................01/01/0001
A..............................................02/01/0001
B..............................................01/01/0001
B..............................................02/01/0001
B..............................................02/01/0001
C..............................................01/01/0001
What I need is this query:
EmployeeName................DateOfRegistry................................Number
A..............................................01/01/0001..............................................1
A..............................................01/01/0001..............................................2
A..............................................02/01/0001..............................................1
B..............................................01/01/0001..............................................1
B..............................................02/01/0001..............................................1
B..............................................02/01/0001..............................................2
B..............................................02/01/0001..............................................3
C..............................................01/01/0001..............................................1
What should I do!? I need a query here!!
Here is the question!
I have a table as below, named tblRollcall, with two fields (EmployeeName and DateOfRegistry). I need to number each record based on these two different fields.
EmployeeName................DateOfRegistry
A..............................................01/01/0001
A..............................................01/01/0001
A..............................................02/01/0001
B..............................................01/01/0001
B..............................................02/01/0001
B..............................................02/01/0001
C..............................................01/01/0001
What I need is this query:
EmployeeName................DateOfRegistry................................Number
A..............................................01/01/0001..............................................1
A..............................................01/01/0001..............................................2
A..............................................02/01/0001..............................................1
B..............................................01/01/0001..............................................1
B..............................................02/01/0001..............................................1
B..............................................02/01/0001..............................................2
B..............................................02/01/0001..............................................3
C..............................................01/01/0001..............................................1
What should I do!? I need a query here!!