Temperature, Humidity, Pressure

[billgyrotech1]

Hello,

On my AFRs Form and Tear Down Report I would like to display:



Temperature:
75℉
Humidity:
35% RH
Pressure:
29.95 Hg


Does anyone know how to do this please? Does the source table need to be formatted?

I appreciate any help

[davegri]

Here's a way. Example if for Humidity, you can figure out the others...

SELECT AFRs.*, AFRsParts.ID, AFRsParts.AFRsID AS AFRsID_AFRsParts, AFRsParts.Qty, AFRsParts.[Part Number], AFRsParts.[PO #], (Humidity*100) & "% RH" AS DHumidity FROM AFRs INNER JOIN AFRsParts ON AFRs.AFRsID = AFRsParts.AFRsID; 

[rpeare]

You can set the control source of the field = Temperature & "F" or =Temperature & "F"

you can do the same thing for the other fields

=Humidity & "% RH"

etc just remember to change the name of the control from temperature to temperaturex or something or it'll get confused and throw an error. Not sure how to get the degree symbol in there, I'm still looking at that part.

[rpeare]

Ok found it, for your degree symbol you want something like

=Temperature & "°F"

to get the degree symbol hold down your alt key and use the NUMERIC KEY PAD to type in 248

ALT-248 will give you the degree symbol

[billgyrotech1]

Thank you I will give it a go.

[billgyrotech1]

I changed the control source on the form and get a number type error.

OOPS I forgot to change the name.

I think it works great thank you.

[billgyrotech1]

My Humidity numbers are like 0.24 which should be 24.0 "Percent symbol" "RH"

How can this be done?

[billgyrotech1]

NOTE: The entries should be 24.0 as they type

[rpeare]

=format([humidity], "Percent") & " RH"

[billgyrotech1]

I now get 24.00% RH

How to ?

24.0 % RH


I must be missing how to get the space and only one decimal place

[rpeare]

=format([humidity] * 100, "00.0") & " % RH"

[billgyrotech1]

That is perfect thank you