Unanswered: How to Define a Default Value for a Microsoft Access Field
Hi everybody, i have a problem in Access 2000.
I want to assign some field values to one field's default value.
Ex : I have a table contain field A,B,C both is integer.
Now i want default value of C = value of field A + value of field B.
But all this assign in the design mode.
I like to third that notion as well. You posed a question and got the correct answer for it. DEFAULTvalue means the Value of THAT particular field. What you are wanting is a CALCULATED FIELD and that is done either in your QUERY, FORM or REPORT by placing usually a Text field to hold that calculated value. Example of a Default Value is like in a Date field where you want the CurrentDate to be the default, and would do so by placing "Date()" in the DefaultValue field. Just remember, you CAN'T place a Calculated Field in your Table. Table only Hold the information for you. Queries and the such Display it and Calculate it for you.