How do I create a calculated bound field in a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pretty new to creating databases and forms in Access but am pretty sure
what I want to do can get done. I have an automatic ID number that is
generated. We need to have a second numbers randomly created. So I want to
take the first ID number and just add 30000 to it. How do I do this in a form
and have the second number be bound to a field in the same table?
 
Why would you bind it to the table? That is duplicating data. When you
wnat to pull that calculated number to a report, query, or for, simply
calculate it.

Good database design dictates that you almost never store a calculated
field. The only exception would be in cases where the calculation may
change (such as a discounted price paid on a particular invoice).

Rick B
 
Back
Top