var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
help! I have a table and want the status field to read outstanding if it is empty. Do I have to do this with a query and set a new column where if [Status] is null = outstanding becuase I've tried that and can't get it to work!
Have you tried setting the default value for that field to "Outstanding" in the table properties?
hmmm but I only want it to be outstanding if the preievious date column is after a specified date i.e. [Build date]>date()
OK, I would use an expression in my query, something like-
Excelent thankyou that helped alot
Build Status1: IIf(([qu:autodates].[Build by])<Date() And [tb:tool_room].[Build status] Is Null,'O/S',IIf([tb:tool_room].[Build status] Is Not Null,[build status]))