Search results

  1. T

    linking excel sheet to access and adjust access table format.

    I would like to use Access as a source for my pivot tables as i am trying to build a pivot table based on 10 different excel sheets. so I performed the following: 1. I linked the excel sheets into Access 2. created a Union Query between the two tables in access 3. created a pivot table in...
  2. T

    Scenario-help (posted in Macros too)

    Hope I am posting my question in the correct place. First of all I am entry level user in access, but knowledgeable in excel. As I am working with data containing over 65,000 rows I decided to use access however I don’t know how create a function that will work give the same result as (vlookup)...
  3. T

    scenario-help

    Hope I am posting my question in the correct place. First of all I am entry level user in access, but knowledgeable in excel. As I am working with data containing over 65,000 rows I decided to use access however I don’t know how create a function that will work give the same result as...
Back
Top Bottom