I have a Query which shows info from a table, tbl.RawData.
And within this query I have a few fields which perform simple equations with the info taken from the table.
One of the fields with an equation gives me the #error result when it has a row with zero results in them. The zero result will eventually be populated with a value, but until that happens I get #error.
The equation I put in the field CostPerSqFt is as follows:
nz([Phase1and2])/([TotalSquareFt])
there will be times when the field Phase1and2 will be empty and also TotalSquareFt will be empty.....sometimes they will both be empty and other times it will be one or the other......in the end they will BOTH be populated but but during that time before there's a 0.00 result in the two fields (Phase1and2 and TotalSqFt).
The ones where they (the two fields mentioned above) are not both populated I get the #error in the CostPerSqFt field.
Is there a way to make the CostPerSqFt field value be 0.00 until both other fields are populated with a value?
And within this query I have a few fields which perform simple equations with the info taken from the table.
One of the fields with an equation gives me the #error result when it has a row with zero results in them. The zero result will eventually be populated with a value, but until that happens I get #error.
The equation I put in the field CostPerSqFt is as follows:
nz([Phase1and2])/([TotalSquareFt])
there will be times when the field Phase1and2 will be empty and also TotalSquareFt will be empty.....sometimes they will both be empty and other times it will be one or the other......in the end they will BOTH be populated but but during that time before there's a 0.00 result in the two fields (Phase1and2 and TotalSqFt).
The ones where they (the two fields mentioned above) are not both populated I get the #error in the CostPerSqFt field.
Is there a way to make the CostPerSqFt field value be 0.00 until both other fields are populated with a value?
Last edited: