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 |
#11
|
|||
|
|||
Brain Cramp Db design
BABs -
Your guage spreadsheet sounds normalized - one record per guage, all data dealing with the guage. That should convert easily to a table. You should be able to import it pretty much as is, selecting the guageID as the primary key. Your guage readings datae is not normalized. You will want your new table to hold the GuageID, ReadingDate, and GuageReading, with the GuageID and ReadingDate together as the primary key. You can make a copy of your guage reading spreadsheet and make changes there to allow you to copy/paste this data into your new table. Insert a column between your date and guage 1 columns, and put the guageID (maybe this is "guage 1"?) down the whole column. Then the first three columns of your spreadsheet match the format of the guage readings table. Then you can change column B to contain "guage 2" and delete column C (the reading for guage 1 that you already pasted into your table). Now the first three columns have the data you need for the second guage. Copy/Paste these into your guage readings table. Continue on for all the guages. Hope that helps! -- Daryl S "BABs" wrote: 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 |
#12
|
|||
|
|||
Brain Cramp Db design
BABs -
Your guage spreadsheet sounds normalized - one record per guage, all data dealing with the guage. That should convert easily to a table. You should be able to import it pretty much as is, selecting the guageID as the primary key. Your guage readings datae is not normalized. You will want your new table to hold the GuageID, ReadingDate, and GuageReading, with the GuageID and ReadingDate together as the primary key. You can make a copy of your guage reading spreadsheet and make changes there to allow you to copy/paste this data into your new table. Insert a column between your date and guage 1 columns, and put the guageID (maybe this is "guage 1"?) down the whole column. Then the first three columns of your spreadsheet match the format of the guage readings table. Then you can change column B to contain "guage 2" and delete column C (the reading for guage 1 that you already pasted into your table). Now the first three columns have the data you need for the second guage. Copy/Paste these into your guage readings table. Continue on for all the guages. Hope that helps! -- Daryl S "BABs" wrote: 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 |
#13
|
|||
|
|||
Brain Cramp Db design
BABs -
Your guage spreadsheet sounds normalized - one record per guage, all data dealing with the guage. That should convert easily to a table. You should be able to import it pretty much as is, selecting the guageID as the primary key. Your guage readings datae is not normalized. You will want your new table to hold the GuageID, ReadingDate, and GuageReading, with the GuageID and ReadingDate together as the primary key. You can make a copy of your guage reading spreadsheet and make changes there to allow you to copy/paste this data into your new table. Insert a column between your date and guage 1 columns, and put the guageID (maybe this is "guage 1"?) down the whole column. Then the first three columns of your spreadsheet match the format of the guage readings table. Then you can change column B to contain "guage 2" and delete column C (the reading for guage 1 that you already pasted into your table). Now the first three columns have the data you need for the second guage. Copy/Paste these into your guage readings table. Continue on for all the guages. Hope that helps! -- Daryl S "BABs" wrote: 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 |
#14
|
|||
|
|||
Brain Cramp Db design
I would like to offer to help you. I provide fee-based basic help with
Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve "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 |
#15
|
|||
|
|||
Brain Cramp Db design
I would like to offer to help you. I provide fee-based basic help with
Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve "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 |
#16
|
|||
|
|||
Brain Cramp Db design
I would like to offer to help you. I provide fee-based basic help with
Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve "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 |
#17
|
|||
|
|||
Brain Cramp Db design - stevie pimps again
"Steve" wrote in message
... I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. John... Visio MVP |
#18
|
|||
|
|||
Brain Cramp Db design - stevie pimps again
"Steve" wrote in message
... I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. John... Visio MVP |
#19
|
|||
|
|||
Brain Cramp Db design - stevie pimps again
"Steve" wrote in message
... I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. John... Visio MVP |
#20
|
|||
|
|||
Brain Cramp Db design
"Steve" schreef in bericht ... I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. You would offer the same crappy help as in 'Setting up Observation Database' ?? Nevertheless... Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.500 pageloads... it's a shame !!) Arno R |
Thread Tools | |
Display Modes | |
|
|