Question no 2

[Kevin Field]

Next question,

I have another field in the report which is called RegularPremiumFrequency and this pulls its value from a table i have with all of the main policy data.

I want the value to always be what is in the table against that policy i.e. Monthly or Annually.

However, if there is no value in the field then i want it to default to say 'Single'.

What formula should i use to make this happen? Again, in Expression builder if possible.

Thanks!

 

[vbaInet]

This one is very similar to the last solution I gave. Maybe this link would explain the IIF function I used:

http://www.techonthenet.com/access/functions/advanced/iif.php

 

[Kevin Field]

Again, thanks. Helped a treat.

 

[vbaInet]

Great!!! You're welcome.