gl code

[subs]

= Sum(iif(left([Gl code])="2";[Total paid amt];null))

this is showing syntax error in access report design . can i know why
pls help thx

i want to add up total paid amt column only when gl code starts with
digit 2.

 

[MGFoster]

= Sum(iif(left([Gl code])="2";[Total paid amt];null))

this is showing syntax error in access report design . can i know why
pls help thx

i want to add up total paid amt column only when gl code starts with
digit 2.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If should be:

=Sum(IIf(Left([GL code],1)="2", [Total paid mat], NULL))

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSo48mIechKqOuFEgEQIOUwCgj7xg8l+DSrn46FKmoZCYpcJZSEwAn33I
dkLETNQ1vORe/rJJJFBtHLNh
=EEmf
-----END PGP SIGNATURE-----