I think he’s talking about a different technique where you pull the subquery in through the calculated field, and like them through subquery criteria instead of joining tables the normal way. It works great if you are returning a single value. It doesn’t work if you want more than one value from the table you are pulling from. This thread explains that technique.
Banderson
(Brandon Anderson)
11
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| BAQ to evaluate consecutive rows in table | 13 | 5090 | March 26, 2019 | |
| BAQ to select one row from partTran where MAX(TranDate)? | 6 | 1934 | October 22, 2020 | |
| BAQ Subquery to return one row (TOP 1) | 3 | 1550 | March 9, 2024 | |
| BAQ to get quantities for all parts on a specific date | 15 | 10387 | June 11, 2024 | |
| Return only one job per part | 13 | 1062 | September 6, 2019 |