Can't Format a field in a Query thats Calculated

[DJRhino1175]

ProductionLost: Nz(([UnplannedDowntime]+[sumofchangeoverminutes])*[AvgOfCalcLineSpeed],0)

I can put in the format as Standard, but it will not allow me to change the decimal place.

What did I do wrong?

Thanks for the help.

[NeoPa]

As you've used NZ(), it doesn't realise that the result is numeric. NZ() returns a Variant value.

Try instead :

ProductionLost: CDbl(Nz(([UnplannedDowntime]+[sumofchangeoverminutes])*[AvgOfCalcLineSpeed],0))

Another type-conversion function may suit you better but this one will work and illustrates the point well enough.

[DJRhino1175]

Thank you, this worked awesomely. I'll need to remember that one.

[NeoPa]

Any time DJ :-)

Glad I could help.