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

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

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

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

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

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

"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

"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

"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

"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