Sep 15 2010, 05:07 PM
Can you set a "Default Value" for a record in a table using a query?
Sep 15 2010, 06:11 PM
We may be thinking about two different things.
In Access, a "default" value in a table is the value which will be added WHEN A NEW RECORD IS ADDED, provided no other value is entered for that field (in other words, use "X" as a default value). If this is what you are after, open the table in design view, select the field, and set the default value.
It sounds like you might be looking for a way to SET values in records that already exist. If this is what you need, create an UPDATE query (see Access HELP for details).
Sep 16 2010, 09:46 AM
If I may help this article is good to read. The above advise also was very good.http://office.microsoft.com/en-in/access-h...A010096451.aspx