Displaying fields based on contents of another

[t16turbo]

hi there,

I have 3 date fields in my table I querying, client_date, internal_date, design_date.

I need to do some analysis of my project_code field in order to display different dates.
here's the logic:

1. check 7th digit in field PROJECT_CODE
2. if 7th digit is 'D', then display 'client_date' and 'internal_date' (with labels). If 7th digit is 'S', display only 'design_date' (plus label)

I haven't got a clue how to go about this at all!
can someone point me in the right direction with how to tackle this problem.

thanks in advance!

 

[h0h0h0]

Throw some Actuate Basic code in the details section that will check the digit and set the size.height/width = 0 for the fields you wish to hide.