Access noob to say the least!

[IronMan1982]

Hi All,

I'm in desperate need of some help. I have a list of spreadsheets that each contain a unique ID for a business.

what i am trying to do is create a database in access so that i can run a query on the unique ID and it will return all the results from all the spreadsheets for that ID...

i have attached a link as the picture wont link properly to give some more context...I haven't used access since I was 16! so really could do with the help unless there's an easier way to do it in Excel?

https://drive.google.com/file/d/0B9I1WU_jgoIVckVyLTl5Vm1pVXc/view?usp=sharing

Thanks in advance for your help.

 

[Micron]

The information you supplied is too sketchy to do much more than give broad suggestions.
- you could use Microsoft Query in Excel and do something with the data in a workbook; either one of the ones you mention or one that consolidates the data via a query.
- you could link each of the sheets as a table in Access (1 per table) and join the fields (Access term, akin to column in Excel) to each other in a query. You'd add each table to the query and assuming they were positioned left to right in the query design view, join the fields that contain the ID from one to the next. If you wish to find all the records from all the tables that contain a particular ID, you need only put that ID as criteria in one of the fields in the criteria grid.