[SOLVED] Autopopulate empty fields with values from another field.
I have a table which contains data on Number of offspring and Number alive imported from an Excel spreadsheet.
Number of offspring always contain value while Number alive is sometimes empty. I would like an empty row of Number alive to be auto-populated from Number of offspring and leave "as-is" if the row is not empty.
This could be accomplished in a form or report but I would prefer to do it during import using VBA or using Update Query to save it to the table, but I can't figure out how.
TIA!
I have a table which contains data on Number of offspring and Number alive imported from an Excel spreadsheet.
Number of offspring always contain value while Number alive is sometimes empty. I would like an empty row of Number alive to be auto-populated from Number of offspring and leave "as-is" if the row is not empty.
This could be accomplished in a form or report but I would prefer to do it during import using VBA or using Update Query to save it to the table, but I can't figure out how.
TIA!
Last edited: