Nulls making a mess!
in [Queries]
|
Prev: MS Access Not Responding Make Table Qry
Next: Adding Sequential numbers to a new feld in access table.
From: ant1983 on 21 Jan 2010 13:56 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?
From: KARL DEWEY on 21 Jan 2010 14:32 Try this -- TurnoutRate: Format(nz([Total Of CountOfnumAttended]/[Total Of CountOfnumTrainingSessionID],0), "Percent") -- Build a little, test a little. "ant1983" wrote: > 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? > >
From: vanderghast on 21 Jan 2010 14:35 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 "ant1983" <ant1983(a)discussions.microsoft.com> wrote in message news:0BDAB595-7637-4C16-AEF4-8000DA573C35(a)microsoft.com... > 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? > >
From: ant1983 on 24 Jan 2010 02:49
Fixed it! :) Changed it to: TurnoutRate: nz([Total Of CountOfnumAttended]/[Total Of CountOfnumTrainingSessionID],0)*1 "ant1983" wrote: > 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? > > |