Nulls making a mess!

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Ive posted two questions and i cant find them now so heres goes the 3rd:

I have a query and want the blank fields to reflect as zeros. I do this by:

BookedMOM: nz([qryStatsBookingsBreakdown_Crosstab].[MOM],0)

My problem is with this field: TurnoutRate: nz([Total Of
CountOfnumAttended]/[Total Of CountOfnumTrainingSessionID],0)

Its a percentage field so it changes it to a numer from 75% to 0.75 How do
i get it back to PErcentage? When i check the properties it still says
Percent?
 
Try this --
TurnoutRate: Format(nz([Total Of CountOfnumAttended]/[Total Of
CountOfnumTrainingSessionID],0), "Percent")
 
In Design view of the query, have the property sheet visible. Click on the
first line of the grid, for that expression, the properties should be:
Description, Format, Caption and Smart Tags. The Format property should
present you with a combo box in which you will have Percent.


Vanderghast, Access MVP
 
Fixed it! :) Changed it to:

TurnoutRate: nz([Total Of CountOfnumAttended]/[Total Of
CountOfnumTrainingSessionID],0)*1
 
Back
Top