Replace #Error with Standard Message 1

[Mike555]

I have the following expression in a query:
FirstDayofWeek: [DateAdded]-Format([DateAdded],"w",2)

My problem is that whenever the DateAdded field is blank the message #Error appears. Is it possible for me to modify the expression so that records returning #Error simply just display a null field?

Thanks.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[Darrylles]

Hi,

FirstDayofWeek: iif(isnull([DateAdded]), "",[DateAdded]-Format([DateAdded],"w",2))

Not tested, but essentially says:

if Dateadded is null, then result = "", else your formula.

iif works like this:

iif (condition , statement_if_true, statement_if_false)

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[Mike555]

Cheers Darrylle! Worked Perfectly!

--
Mike

Why make it simple and efficient when it can be complex and wonderful?