Need to display a zero

[Oscar_W]

Hi,
The following control in a report displays the number of people with surnames the same as those who served onboard HMS Victory during the battle of Trafalgar:

[In VICTORY.CountOfCountOfSurname] & " " & [surname] & " - in VICTORY."

It works fine but if there are no matches, it just displays " Smith - in VICTORY.", how can I make it display "0 Smith - in VICTORY."

Thanks in advance,
Oscar

NB. Actually there were 16 Smiths in case anyone is interested!

 

[boblarson]

IIF(IsNull([In VICTORY.CountOfCountOfSurname]),0, & " " & [surname] & " - in VICTORY.")

 

[Oscar_W]

Many thanks for the very speedy response but that is giving me two errors? When I type it into the control box it says that it has an "invalid control source". If I ignore that and try and display the report, I get an error that tells me there are too many ")"
I have tried mucking about with the number of brackets but no joy yet

 

[Oscar_W]

Sorted it.

=IIf(IsNull([In VICTORY.CountOfCountOfSurname]),0 & " " & [surname] & " in Victory",([In VICTORY.CountOfCountOfSurname]) & " " & [surname] & " in Victory")

Many thanks for the initial steer.