Search results

Hi there freakazeud, I am having the same issue and i am positive the excel column is formatted as "number", but when the excel sheets linked to access (via File - Get external data - Link Tables) the field "No of Products" which is formatted in excel as a "Number" shown in access as "Double"...

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

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)...

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