Space Cowboy
Member
- Local time
- Today, 08:30
- Joined
- May 19, 2024
- Messages
- 245
Good afternoon good people,
How many joins can you have on a table?
How many joins can you have on a table?
Number of joins in a query: 16Access specifications - Microsoft SupportFind limits and specifications for Access 2016 database files and objects, such as the maximum file size or the maximum number of fields in a table.
support.microsoft.com
|
but I will still need to link to the original table again eventually.
It seemed to me inefficient. to go round and round through the same table.
I think I will be able to nest the calculations so they are done first, then include them in the query. is best way SQL or VBA?From what you have described, it doesn't sound necessary to keep coming back to the original table--just include all the fields you want along with those calculated fields. That way that first query you build has the calculations and the fields you will need later.
Perhaps a sample database or more concrete example specific to your situation would help us see your situation better.
Ah, I was looking at the table area only. Cheers!
Number of joins in a query: 16
Access specifications - Microsoft Support
Find limits and specifications for Access 2016 database files and objects, such as the maximum file size or the maximum number of fields in a table.support.microsoft.com
Good afternoon good people,
How many joins can you have on a table?
I think I will be able to nest the calculations so they are done first, then include them in the query. is best way SQL or VBA?
50* nested queries. ye ha!
Good afternoon good people,
How many joins can you have on a table?
The limit is 16 joins in a query. Typically the heart of the query is only 2 or three tables that create a hierarchy. The other joins are to lookup tables.I thought I could use the general table with four or five links and get all the info in one query, I think it will take longer and be slower but logically less complicated.