Recently, the names of the "Microsoft: Access" forums were changed in order to clarify the purpose or focus of each forum. The number of posts in the "General" forum exceeded the number of posts in all other Access forums every week. The "General" forum is now named "Microsoft: Access Other topics." The Other forum will appear at the end of the list of Access forums.
I recommend carefully reviewing the purposes of the various forums and selecting the forum that focuses on your issue or question. If we all endeavor to do this we will spread questions more evenly through the forums. This will make it easier to get and provide answers.
NOTE: This annoucement was orignally posted in Thread181-231806 of the "Microsoft: Access Other topics" forum. Members have posted several suggestions to the thread.
Focus: Questions and discussion about creating and running queries in Access. Suitable topics can include but are not limited to: SYNTAX - Proper syntax for queries and the various parts of queries such as clauses, predicates, table and column names, aliases... JOIN - INNER, OUTER, and CROSS JOINs, capabilities and limitations UNION - When to use UNION queries, when to use UNION ALL... FUNCTION - When and how to use built-in and user-defined functions within queries TOTAL or AGGREGATE queries - How and when to use aggregate functions, GROUP BY... CROSSTAB or PIVOT queries - Creating CROSSTAB queries ORDER BY clause - How to use effectively, ordering by columns not in the SELECT list, ordering by functions SUB-QUERIES - Appropriate use of sub-queries, problems and limitations of sub-queries, derived tables... PASS-THROUGH QUERIES - When and how to use, capabilities and limitations, performance issues... PERFORMANCE - How to optimize queries, query constructs that produce poor performance, efficient query constructs...
Note: Jet SQL is the version of SQL used in Access. It differs from ANSI SQL, T-SQL and other versions of SQL.
Focus: Questions and discussion on specifically related to creation and use of Access Project files which connect to a SQL Server back-end database.
Forum181 - Microsoft: Access Other topics Focus: Access topics that don't seem to fit in one of the other forums. These could include but are not limited to: Security, DB corruption and repair, Internet deployment, Access options, version differences, upgrading...Please add your comments and ideas to Thread181-231806 so we can continue to work together to improve the value of the Tek-Tips forums and keep this place rockin'.