Newbie format number problem

[mrbob2]

Hi, I have a Computerized Maintenance Management System (CMMS) and I am trying to build some queries to better understand the data. I built a querie that returns the information I want except that the numbers have 13 digits to the right of the decimal point.


The format function does not work and I tried to write an expression to change it but I seem to be missing something.
Here is a copy of the querie.
workorders Query2AssetNoSum Of DownTimeA1010.866666666666667A1020.65A1035.48333333333333A1051B1015.91666666666667Bano12CH0050.333333333333333E5031.33333333333333E5051E5061E5071E5081.25E5094E5100.583333333333333G1010.833333333333333G1030.833333333333333H10018.95H10155.8166666666667H10218.0333333333333HL1000.25I1007.01666666666667I10114.7666666666667I10219.1166666666667L1011.21666666666667L1020.366666666666667M1020.666666666666667M1051.25M1061M1080.5PT10.8PT20.75RG1013TM021TM040.166666666666667V1000.5W1000.433333333333333W1012W1022.5W1050.5W1071W1081.63333333333333WV129.1666666666667

Thanks, Bob

[RuralGuy]

You may want to post again. I doubt it turned out the way you intended.

[mrbob2]

Hi, I have a Computerized Maintenance Management System (CMMS) and I am trying to build some queries to better understand the data. I built a querie that returns the information I want except that the numbers have 13 digits to the right of the decimal point.
The format function does not work and I tried to write an expression to change it but I seem to be missing something.
I wrote:
format ("Sum Of Downtime","0.0")
I also tried:
format (Sum Of DownTime: DownTime, [fixed]) this gave me an error that said the-
words need to be in " " This gives me a expression drop down box when I open the querie. It is asking for a input
Here is a copy of the querie.
------------------------------------------------------
| AssetNo | Sum Of DownTime: Downtime |
------------------------------------------------------
| A101 | 0.866666666666667 |
------------------------------------------------------
| A102 | 0.65 |
------------------------------------------------------
| A103 | 5.48333333333333 |
------------------------------------------------------
| A105 | 1 |
------------------------------------------------------
| B101 | 5.91666666666667 |
------------------------------------------------------
| Bano1 | 2 |
------------------------------------------------------
| CH005 | 0.333333333333333 |
------------------------------------------------------
| E503 | 1.33333333333333 |
------------------------------------------------------

[RuralGuy]

Welcome to the site Bob. How about posting the SQL for your query so we can look at it?

[ConneXionLost]

Hi mrbob2,

Open your query in design view. Right click on your "Sum Of DownTime: Downtime" field column and select "Properties".

When the Field Properties are displayed, enter your desired format (Fixed?) on the Format row.

Close the Field Properties dialog box, and rerun your query.

Cheers,

[mrbob2]

Hi, Here is a copy of my Query. I hope this is what you want.
Thanks, Bob

[mrbob2]

I thought that was all I needed to do but there is no properties option in the right click of this field.???

[RuralGuy]

Here's what ConneXionLost was suggesting.

[mrbob2]

Thanks for showing me that I am a F#$^*ng bone head. I totally forgot about doing that in design view. I could not understand why I was having such a hard time with such a simple task.
Thanks again for all your help,
Bob

[RuralGuy]

Just glad we could help Bob.