converting units in Access

[jtabb]

I have a table with various flowrates in liters/second. I would like for them to be in gallons/minute. I know the conversion factor is 1 L/S= 15.82 GPM. How can I use Access to convert all of the values in the column from L/S to GPM?

 

[LittleSmudge]

Raplace table and field names as appropriate:-

In a new query in SQL view type the following


UPDATE tblDataTable SET FlowRate = 15.82 * FlowRate ;


and then run the query.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Darrylles]

Hi,

There are 2 options:

Add another field to each litre/second record and apply the function to populate this field with gals/minute, or: calculate the gals/minute value if and when needed.

(In reality, neither should be stored anyway - I'm sure that flowrate can be calculated from lesser table info.)

Kind regards,

Darrylle


Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[LittleSmudge]

Add another field to each litre/second record

No NO NO



If you want to retain the old data then JUST do the conversion when you display the results on the Form or Report.

If, as I suspect, you no longer want to keep the old format then do as above.

There is NO good reason at all for duplicating the data by adding an additional field.
( See: Normalisation, Codd Rules, etc. )





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.