Counting with parameters in an unbound box

[modex]

On a form I would like to have a number of unbound boxes that show the count of titles that start with a given letter. I just cant work out the coding. Could anyone help please.
I have tried this, but is doesnt work
=count(left([title],1)="a*",1,0)
Any help would be appreciated.

Also, is there any way of converting a null value in an unbound box from null to numeric 0 so that when I add field together they give a total when one of the fields are empty.

Many thanks

ModeX

 

[Rich@ITTC]

Hi Modex

Try this:

=Sum(IIf((Left([title],1)="a"),1,0))

For Null values use the Nz function (see Help files for details).

HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 04-18-2001).]