Determine Repeat Record in Detail?

[CraigBest]

OK, here I am again.

I gave up on the Nested If (The suggested solutions worked, I had a different problem with Variable Scope) and I have changed the way I'm attacking the problem. Each field now has a series of its own if/else statements that affect only that formula field. That seems to be working for the single transaction records, but I have a situation with Exchanges, because they appear as separate Buy and Sell records joined with an identical arbitrary code.

I need to show the two records as one, and populate the From and To formula fields differently if it is an exchange. I have been trying to set up a control-break process in a formula to control this, where I save the last record code and compare it to the current record code. If they are the same it is an exchange, and I should handle it differently. If different, they get written as single records.

The problem is I can't figure out where and how to set up the test for old = new, and after processing is done update the old code with the current record code.

Any suggestions on how I can do this? Or another method?

 

[idle]

Why not just group the records by "record code"? That way, your formulas can do the work in the (hidden) detail section, then you can display the results in the group footer.

 

[CraigBest]

Idle,

I was already doing that. I could not get the formula fields in the Group below the detail section to show any of the variable values.

Anyway, I've given up and I'm re-writing the whle thing in VB. I've wasted too much time on this project already.