I have a table with a numeric field. Some of the fields contain zero values. For the purpose of calculating an average I want to ignore these fields.
How do I make them null.
.
Re: How do I replace error messages in Access? ... In my reports I often have to calculate the ... problem is in calculating the % difference i.e. zero divided by zero when the ... IIf statements and I have not been able to get rid of the MS error message.... (microsoft.public.access.queries)
Re: Need urgent help with SUMPRODUCT() ... something to do with why it is not calculating or give incorrect calculation. ... and stop seq are text field and time are numeric fields. ... Should I change the start and stop sequence to numeric field instead? ...Microsoft Excel MVP... (microsoft.public.excel.misc)
Mark a task 100% complete ... Work" when marking a task 100% complete?" ... than open each task and set remaining work to zero manually.... Office Project 2003 calculates the actual work (actual work: The amount... work to zero rather than calculating actual work based on planned work? ... (microsoft.public.project)
Re: IF Statement Question ... When calculating... >> trying to calculate a forecast accuracy.... >> column A or B is equal to zero then enter a zero % accuarcy,... (microsoft.public.excel.worksheet.functions)
Re: Mark a task 100% complete ... I don't know if this will help or not, but usually when tracking tasks I ... the Actual Work, zero out remaining work. ...amount of work, in terms of a time unit such as hours or days, that is ... work to zero rather than calculating actual work based on planned ... (microsoft.public.project)
