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!
Search results for query: *
- Users: PatHartman
- Order by date
-
New Access user, need Help with UPDATE
Access queries that include domain functions are not updateable. To accomplish your purpose change the count query to a make table query then run the update query by joining to the table you just made to hold the counts. It is generally poor practice to store data that can be easily calculated...- PatHartman
- Post #2
- Forum: Microsoft: Access Other topics
-
Reference table column computationally in sql query - how
It sounds like a table design issue. The columns 1-5 should probably be rows with a type code. Then you could do the join as you envision. It is not possible to "parameterize" anything in a query other than variables in the where clause. SQL is not a programming language the way...- PatHartman
- Post #4
- Forum: Microsoft: Access Other topics
