Search results for query: *

Jim, The field is located in a form and also in a report. Calculations are done in a query and then displayed in a field on a form generated by this query (that was an experiment to try get rid of the #Error but did not work, the calculations were previously done in the field on the form)What I...

Micheal, So far it is working well. Do you have any other suggestions which may not cause confusion? Thanks Kevin

Thank you so much Jim Horton it worked

Thanks so much John It worked

How do prevent getting an error message in a field when the field contains an expression that has a division by zero. The expression is " [parts]/hours]/8)" Whenever "hours" is zero, I get the error message "#Error" in the field. Someone recomended an error check...

Terry The form is generated by a query, I have tried the Nz function before and it did not work. Going back to the expression " [start3]/([# Of Hours Worked3]/8)" all these fields are kept in a table and already have zeros in them before data entry, so if no data is entered it will...

How do prevent getting an error message in a field when the field contains an expression that has a division by zero. The expression is " [start3]/([# Of Hours Worked3]/8)" Whenever "Of Hours Worked3" is zero, I get the error message "#Error" in the field. Someone...