I am desiging an access form with auto records, such as an auto number (transaction number), an auto date (today's date), and fields that are populated with sums of other fields, ie one field divided by another.
I am then trying to append these records to a table but when I append it the records that update automatically come accross as blank.
Is there any way to append this information to the table? The form is a front end screen to input transaction information which then populates a transaction table.
I hope this makes sense!!
Many thanks,
Claire
I am then trying to append these records to a table but when I append it the records that update automatically come accross as blank.
Is there any way to append this information to the table? The form is a front end screen to input transaction information which then populates a transaction table.
I hope this makes sense!!
Many thanks,
Claire