a formula in a table field... ...smth like an autocomplete

[abyss]

hi,
i'm absolutely new in access
im having some newbie problems....

at the moment i'm trying to create a table (wow!)
is there any posibility to add a field with formula. smth like that:

field_rest=field_books-field_sold

many thx ray:

 

[anvil19]

Re: a formula in a table field... ...smth like an autocompl

Hey abyss

No table should have a field that is dependent on other fields for it's values, I don't even think it's possible in Access to do so. If you wish to have a field that calculates a value then you should create a query that displays that data.

anvil19

 

[abyss]

Re: a formula in a table field... ...smth like an autocompl

ok, thx,

but what about "default value" property? ah? i saw a formula posibility there..... ....but dunno how to write that formula. doh!

=[boox]-[sold] or smth.... ..any ideas about that?

 

[anvil19]

Re: a formula in a table field... ...smth like an autocompl

Hi abyss

Try as I might, I cannot get Access to save a table that has an aggregate function as a default value. Even my Access bible, the Access 2000 Developers Handbook does not seem to allow for it.

I tried =SUM(value1-value2), just SUM(value1-value2), =(value1-value2) and (value1-value2), but no go!

I think you will have to view such a table as a query.

anvil19