Saphirah
Active member
- Local time
- Today, 23:10
- Joined
- Apr 5, 2020
- Messages
- 163
Hello everyone,
Coming from a programming background i like having independent systems, and reusing old "functions". Same applies for SQL queries.
i created multiple subqueries to show data in the format i need. For example i have a query which shows all customers in the format [Name] & [Postcode] & [City], and in various other formats. Now my question is, when i append the subquery to a form query, and only select one field, does access have to calculate all fields or just this one?
When creating complex queries it often happens that i reuse previously created subqueries. This results in a depth of 3 or more subqueries being used inside each other.
If you have the choice, should you rather link the tables directly? Or is it fine to use the subqueries like this?
Oh and one more thing. Should i avoid using calculated fields and iif's in subqueries?
Thank you very much for your time!
Coming from a programming background i like having independent systems, and reusing old "functions". Same applies for SQL queries.
i created multiple subqueries to show data in the format i need. For example i have a query which shows all customers in the format [Name] & [Postcode] & [City], and in various other formats. Now my question is, when i append the subquery to a form query, and only select one field, does access have to calculate all fields or just this one?
When creating complex queries it often happens that i reuse previously created subqueries. This results in a depth of 3 or more subqueries being used inside each other.
If you have the choice, should you rather link the tables directly? Or is it fine to use the subqueries like this?
Oh and one more thing. Should i avoid using calculated fields and iif's in subqueries?
Thank you very much for your time!