Autopopulate table field from query calculation

[rjk1080]

How do you auto populate a table field with calculated results from a query? I have selected a data type of number and combo box for the field properties on the lookup tab. It is not supposed to be a selection. I am wanting the result for the corresponding record to autopopulate. I have resorted to this so far because using calculated field will not populate if any of the fields are null. When looking for that answer, it seems that the Nz function is preferred but Nz is unavailable in the table expression builder. It is available through the query. Also, the query uses this same table so I am unable to use the lookup wizard. Thank you for any assistance. Please let me know if there is more information I can provide.

[davegri]

General advice is to not have calculated fields in tables. If the query has the calculated value needed, use the query in place of the table.