Replicate an Excel Spreadsheet into MicroSoft Access

  • Estado: Closed
  • Premio: $75
  • Propuestas recibidas: 2
  • Ganador: paricoto

Instrucciones del concurso

Replicate an Excel Spreadsheet into Microsoft Access - including functionality. Also need to understand future needs to that its capable of being used for them at a later time. Do not worry about formatting (Fonts, colors....). The winner will need to recreate this in my db when they are finished.

Note the "Replicate [url removed, login to view]" and the "Spreadsheet [url removed, login to view]" attachments are no longer applicable. Contest description has changed some.

Habilidades recomendadas

Principales propuestas de este concurso

Ver más propuestas

Tablero de aclaración pública

  • gehyman22002
    Organizador del concurso
    • 6 meses atrás

    I AM POSTING A NEW EXAMPLE. SCRAP THE ORIGINAL SPREADSHEET. I DONT WANT TO REPLICATE THAT ANYMORE.

    • 6 meses atrás
  • gehyman22002
    Organizador del concurso
    • 6 meses atrás

    To help explain this better. The end goal is for the user to be able to enter hours for each month of the PIDs (Proposal ID Number) period of performance (POP = The months in which the work needs to be done). If there is a way, I suggest adding a ROW Number for each record. This would solve the problem of having each month of the POP already calculated for the user and they do not need to enter or select it. You can do a Formula that finds the first month of the POP and then add the Row to the month (POP Start Month + the Row Number - 1) The minus 1 is only needed if the row number starts with one (1). So the first record would have a field for the month. This would be the calculated field as stated above. I think trying to maintain the layout that was provided in the excel sheet is complicating the task.

    • 6 meses atrás
  • thierrydna
    thierrydna
    • 6 meses atrás

    Please clarify the 3rd slide:
    Am I correct in assuming that the table shown contains the planned completion times for the PID works?
    Where POP month indicates all the months there is work expected to be done to complete it?
    Do you want to 'limit' the user input to only allocate planned time to the period the PID is supposed to be completed?

    • 6 meses atrás
    1. gehyman22002
      Organizador del concurso
      • 6 meses atrás

      Yes the Table show has the start date for the PID and the End Date for the PID. Yes Where the POP Months is where the work is expected to be complete. Yes only allocate planned time to the period.

      • 6 meses atrás
  • gehyman22002
    Organizador del concurso
    • 6 meses atrás

    If this cannot be replicated to look like the spreadsheet layout, alternatives will be considered.

    • 6 meses atrás

Mostrar más comentarios

Cómo comenzar con los concursos

  • Publica tu concurso

    Publica tu concurso Rápido y sencillo

  • Consigue muchísimas propuestas

    Consigue muchísimas propuestas De todo el mundo

  • Adjudica la mejor propuesta

    Adjudica la mejor propuesta Descarga los archivos - ¡Es fácil!

Publica un concurso ahora o únete a nosotros hoy