> It's messy, but you can create 2 fields and place them on top of one another:

> Field 1: iif(type='det',total,'')
> Field 2: iif(type='sub',total,'')

Thanks, but that won't work in this particular case. Well, it would, but there are 8 'total' fields, and four possible states for them to be in (I simplified the example somewhat).

Thanks again.