I have a database that produces timesheets for employees based on employee information and grouped by department information in tblDetail. I have a macro that exports the report Timesheets into excel. I need one Timesheet report to for each department to be exported to excel. So I think I need...
Not sure where to post this.
empid SeqNbr
22222 1
22222 2
33333 1
33333 2
33333 3
55555 1
The query name is PD_COMM.
The main fields are:
EMPLID
EARN_CD
EARN_AMT
EARN_BEGIN_DT
EARN_END_DT
I have a query which has empids. I need to add a sequence number that restarts numbering...
