Search results

  1. J

    create a loop that exports a report to excel based on a field

    I am exporting the report into an excel spreasheet. What I am having trouble is exporting that report into Excel by department. I tried this but it is not working. Private Sub EportTimesheets() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String strSQL = "Select Distinct...
  2. J

    create a loop that exports a report to excel based on a field

    Sorry I should have added background and what I am trying to accomplish. Necessity is the mother to all invention… J They produce a timesheet report from Reportsmith that is connected to the HR system and fax to each department. The departments fax back the time sheets and Payroll manually...
  3. J

    create a loop that exports a report to excel based on a field

    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...
  4. J

    auto assign a sequnce number in a query in MS access

    Any ideas? Thanks :-)
  5. J

    auto assign a sequnce number in a query in MS access

    Basically this is the bonus file that needs to be uploaded into People Soft and People Soft is requiring a sequence for each instance in the bonus file. For example we can have an EMPLID with different Earn_Cd and we need a sequence counter for each instance. I hope I'm making sense. It sounds...
  6. J

    auto assign a sequnce number in a query in MS access

    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...
Back
Top Bottom