All
The 'add calculated field to a table' function in 2010 seems fairly simple and easy... add the column and insert your needs.
Can I assume this is not available in earlier versions of access, my cheapo company only has 2003!!
Novice
Windows XP 
Access 2003
All
The 'add calculated field to a table' function in 2010 seems fairly simple and easy... add the column and insert your needs.
Can I assume this is not available in earlier versions of access, my cheapo company only has 2003!!
Who is John Galt?
Windows XP Access 2007
Your assumption is correct. It's a new "feature" of 2010.
Court Jester
Windows 7 64bit Access 2010 64bit
Most here will likely advise you against storing calculated fields to begin with (except for special circumstances), but rather do it on the fly in a query. Also, it's not just your "cheapo" company. My Fortune 500 is just now getting us Office 2007.
Novice
Windows XP Access 2003
thanks...
Im trying to get a field to update the table field to a compilation of 2 (a&b) other fields when entered in a form, whats the recommended best way? I was using a query, but it appeared to not work on the current/active record...
Novice
Windows XP Access 2003
can you do a query on just the last record... so as not to alter any previously compiled fields?
Master of Nothing
Windows 2K Access 2000
It probably won't update the current/active record while the record is dirty.
You could write a UDF and have the after update event of each of the two controls call the function to update the control. This also allows you to do some data validation...
Calculated Count Field in Access 2010 Table
Posting Permissions
Reply With Quote