List of Contributions

Hi Peter, Thanks for your reply. Really helpful to hear about how the new IIf function works and see a worked example. I have had a play around with it and got it to work as well so it was a good suggestion, I prefer it over the where condition in SQL! Also thanks for pointing out 'You might also use ...

Hi John, Thanks for your reply. Yes, I did think I needed to break it down as such and I've managed to get it all correct now - thanks for your help! Hannah ------------------------------ Hannah Alred Knowledge Community Shared Account ------------------------------

Hi, I have a table with a blank column I would like to fill based on values in other columns from the same table. For example If Column A, B and C contain the value '1', I would like to update Column D (empty column) with the value of '1'. I have written this in the Update Column expression box as: ...