Number Rows in BAQ

[josecgomez]

No you need a calculated field here @Banderson explains it in more detail in this thread.

BAQ to evaluate consecutive rows in table

Occasionally receiving errors happen, causing unexpected changes in part costs. I am trying to write a BAQ to compare the highest-numbered PartTran.TranNum with the next highest one, flagging entries with unit cost changes greater than a threshold. To this end, I’ve created a BAQ with a main subquery to pull in recent PartTran rows for a part in question. And I’ve created a subquery (joined to PartTran with matches on Company & PartNum). What I want from the subquery’s result set is not “All” b…