Database

[Rick]

Ok, I need a little help as I am new to Access. I am trying to import 2
Excel files into Access and then create a quiey or database form them. I
want to be able to ask for X,Y,Z from worksheet 1 and A,B,C from worksheet 2
and have X,Y,Z,A,B,C show up on one page and have an additional column formed
that took Z-C = G (the new column.

 

[John W. Vinson]

Ok, I need a little help as I am new to Access. I am trying to import 2
Excel files into Access and then create a quiey or database form them. I
want to be able to ask for X,Y,Z from worksheet 1 and A,B,C from worksheet 2
and have X,Y,Z,A,B,C show up on one page and have an additional column formed
that took Z-C = G (the new column.

You will need some field in the two spreadsheets that provides a link between
a row in one sheet to its corresponding row in the other. Perhaps you could
post a somewhat more realistic example of your data, perhaps with a few sample
rows of data, and an indication of how Access would be able to tell which X
goes with which A.

 

[Larry Linson]

And, it's good to remember that while it is common, and needful, to store a
calculated value in a spreadsheet, it's neither necessary nor needful to
store a value that can be calculated when needed from other values in the
same record in a relational database.

Larry Linson
Microsoft Office Access MVP