Format Calculation

[bsdixon]

I have a calculatated field in my query and I am not able to format the result of the calculation.

When I go to properties, there is not anything in the format drop down box.

Is there any way to format the result of the query?

Thanks,

Brad

 

[KenHigg]

This:

myCalcFld: [myfld1] + [myfld2]

Can be:

myCalcFld: format([myfld1] + [myfld2], "00.0")

etc...

???
kh

 

[bsdixon]

That code does not seem to work.

I entered this in my query:

Bushels: Format(([Pounds]/60),0.00)

but access automatically changes it to

Bushels: Format(([Pounds]/60),0)

so the number shows up as 8677 instead of 8677.67

Is there anything else I can do?

 

[bsdixon]

I got it to work. Thanks.