If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Brain Cramp Db design
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 |
Thread Tools | |
Display Modes | |
|
|