By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Can I automatically generate a field in a table?

P: n/a
I have a table of contacts that is related (one to many) to a table of
activities. I want to store a field of "MaxDate" for each contact in
the contacts table based on the maximum date of their activity in the
activities table. I know how to do this using a max function in a
query. But, I want the field to automatically generate this data
without my having to run a query. I want it to be stored in the
contact table. How can I do this?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Sorry, you can't. You'll have to run a Update Query.

Personally, I wouldn't store that value. I'd just create it
dynamically, as needed, but feel free to go your own way.

li*****@msn.com wrote:
I have a table of contacts that is related (one to many) to a table of
activities. I want to store a field of "MaxDate" for each contact in
the contacts table based on the maximum date of their activity in the
activities table. I know how to do this using a max function in a
query. But, I want the field to automatically generate this data
without my having to run a query. I want it to be stored in the
contact table. How can I do this?


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.