Hello,
I have calculated values in one query. Is it possible to look up these values from another query and use them in this other query so these values don't have to be re-calculated?
![]()
Hello,
I have calculated values in one query. Is it possible to look up these values from another query and use them in this other query so these values don't have to be re-calculated?
![]()
Yes. Can also use queries in another query. Just like tables. Queries can join to tables or queries.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.