Search results

  1. R

    Access Report - Custom Stacked Line Chart

    Wondering if someone can point me in the right direction. I am updating an access db and one of the reports that gets used a lot is for displaying sieve data. I have attached an example of the current charts output here. The chart is an embedded Microsoft Graph 97 Chart and was created by an...
  2. R

    Incrementing A Value For Every Return In Select Statement

    Trying to increment a value in an SQL SELECT statement. Started with the following: INSERT INTO Table1 (PROJECT, SET_NO) SELECT tblImport.[Project Number], (SELECT MAX(SET_NO) + 1 FROM Table1 INNER JOIN tblImport ON Table1.PROJECT = tblImport.[Project Number]) FROM tblImport INNER JOIN...
  3. R

    Solved Linking form table and subform table from imported excel spreadsheet data

    I have two separate excel spreadsheets. One contains some overview information about a project, whereas the other excel spreadsheet has project specific details that extend multiple rows. Each row in this specific info spreadsheet has an alpha-numeric identifier that can be used to link it to...
Top Bottom