Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update a table through a form 1
- Thread starter dpn2004
- Start date
-
1
- #2
It is normally recommended you don't have a calculated field in a table. You put the calculation into a query and whenever you want to view that piece of information, the query presents it to you based on the data from which it is derived. Only store atomic data in base tables.
It looks like you are uncomfortable with queries and want to limit you dealings to tables. This is a route to heartache. Ideally avoid touching tables and in fact centre all your activities upon queries.
It looks like you are uncomfortable with queries and want to limit you dealings to tables. This is a route to heartache. Ideally avoid touching tables and in fact centre all your activities upon queries.
- Status
Similar threads
- Locked
- Question
- Locked
- Question