I have the following spreadsheet

[circles]

I have the following spreadsheet

Zip loc frame brick Steel
900 2 3 4 5
901 1 2 4 6
902 3 3 3 7
903 2 3 5 6

I am trying to build something that will lookup the numbers in the spreadsheet. For Example if I select the zip 901 and brick the number four should appear. I am hoping there is a way that I can take the headings frame, brick, and steel from this spreadsheet and build a new table called construction type and still be able to keep the associated values. Any insight on how to do this?

 

[HOMMER]

Is this in access or excel

 

[MichaelRed]

Assuming that the current info is in Excel and you want to have in in Ms. Access and Assuming that you are pretty much new to Access in particular and Programming in General. I suggest that you just import the spreadsheet.
Menu
[tab]File
[tab][tab]Get External Data
[tab][tab][tab]Import

Follow the on screen directions.
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over