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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Which Access forum should I choose for my question? Why?
Choosing the Correct Forum
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.
[color maroon]NOTE: This annoucement was orignally posted in thread181-231806 of the "Microsoft: Access Other topics" forum. Members have posted several suggestions to the thread.[/color]
The current forum names and focuses are:
forum702 - Microsoft: Access Forms[ul]Focus: Questions and discussion about creating and using forms in Access, bound and unbound forms, sub-forms, objects on forms, how to navigate forms...[/ul]forum705 - Microsoft: Access Modules (VBA Coding)[ul]Focus: Questions and discussion about writing VBA code, objects, methods, properties, statements, functions...[/ul]forum701 - Microsoft: Access Queries and JET SQL[ul]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...[/ul][color green]Note: Jet SQL is the version of SQL used in Access. It differs from ANSI SQL, T-SQL and other versions of SQL.[/color]
forum703 - Microsoft: Access Reports[ul]Focus: Questions and discussion about creating and using reports in Access, creating totals and sub-totals, grouping, binding to tables or queries...[/ul]forum700 - Microsoft: Access Tables and Relationships[ul]Focus: Questions and discussion on table design, creation, structure, relationships, data types, primary and foreign keys, indexing, linking other data sources...[/ul]forum958 - Microsoft: Access Project (ADP)[ul]Focus: Questions and discussion on specifically related to creation and use of Access Project files which connect to a SQL Server back-end database.[/ul]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...[/ul]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'.
![[rockband]](/data/assets/smilies/rockband.gif "[rockband] [rockband]")
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.
[color maroon]NOTE: This annoucement was orignally posted in thread181-231806 of the "Microsoft: Access Other topics" forum. Members have posted several suggestions to the thread.[/color]
The current forum names and focuses are:
forum702 - Microsoft: Access Forms[ul]Focus: Questions and discussion about creating and using forms in Access, bound and unbound forms, sub-forms, objects on forms, how to navigate forms...[/ul]forum705 - Microsoft: Access Modules (VBA Coding)[ul]Focus: Questions and discussion about writing VBA code, objects, methods, properties, statements, functions...[/ul]forum701 - Microsoft: Access Queries and JET SQL[ul]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...[/ul][color green]Note: Jet SQL is the version of SQL used in Access. It differs from ANSI SQL, T-SQL and other versions of SQL.[/color]
forum703 - Microsoft: Access Reports[ul]Focus: Questions and discussion about creating and using reports in Access, creating totals and sub-totals, grouping, binding to tables or queries...[/ul]forum700 - Microsoft: Access Tables and Relationships[ul]Focus: Questions and discussion on table design, creation, structure, relationships, data types, primary and foreign keys, indexing, linking other data sources...[/ul]forum958 - Microsoft: Access Project (ADP)[ul]Focus: Questions and discussion on specifically related to creation and use of Access Project files which connect to a SQL Server back-end database.[/ul]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...[/ul]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'.