By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

UnitsToElement

P: n/a
I am doing a Water Analysis DB
Structured
Fields
Ca
Mg
Mn
BOD5
PH
etc.
Would like to do a table where the fields of above becomes records ie
Element Unit
Ca g/l
Mg g/l
Mn g/l
BOD5 mg/l
PH -H
etc.
Then have a function that would return the unit from field name
Hope this is clear
thanks
Murray Carter
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
WaterAnalysisResults(
AnalysisID - Long Integer,
ChemicalID - string/long integer (depends on what makes sense)
Measurement - Number of some type
....)

Then you could have a table of Elements (well, loosely speaking,
anyway)

(Element, Unit)
and then you could just link that table to your measurements table and
you'd be all set. But then you MUST be consistent with the units of
measurement.
Then returning the measurement is a simple matter of using a join in a
query... nothing to it.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.