If I have a report or form based on 3 queries:
1st query pulls data from table or multiple tables and filter by criteria (for example date interval)
2nd query is based on 1st - it is a total query that calculates sum
3rd query is based on 2nd query - it converts numbers to words by using a module VBA code.
The problem:
When I open report or form with all 3 queries in i what access does behind the hood?
1.
all queries are executed once.
2.
1st query populates detail section of the report
2nd query populates total sum field but also runs query 1?
3rd query populates numbers to words field but also runs queries 1 and 2?
1st query pulls data from table or multiple tables and filter by criteria (for example date interval)
2nd query is based on 1st - it is a total query that calculates sum
3rd query is based on 2nd query - it converts numbers to words by using a module VBA code.
The problem:
When I open report or form with all 3 queries in i what access does behind the hood?
1.
all queries are executed once.
2.
1st query populates detail section of the report
2nd query populates total sum field but also runs query 1?
3rd query populates numbers to words field but also runs queries 1 and 2?