If you're talking about importing your spreadsheet data into Access, you
need to normalize your second table.
If you're unfamiliar with normalization, see my tutorials page he
http://www.rogersaccesslibrary.com/f...ts.asp?TID=238, especially
"What Is Normalization?" and "Entity-Relationship Diagramming".
Then you can use the method in my sample:NormalizeDenormalize.mdb (
intermediate ) to normalize your gauge readings table.
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
"BABs" wrote in message
...
I am building a new db from excel spreadsheets. One spreadsheet has gauge
information: (each row/record is a different gauge)
gauge serial number - calibration date - load range - location
The second spreadsheet ahs gauge readings by date: (each row/record is a
different date containg data from all gauges)
date - gauge1 - gauge2 - gauge3 - gauge4 - etc
How can I set up the db so I can query for results by date or by gauge
number?
I'm drawing a blank on how to link a row/record to a column......
TIA