Report calculation

[smason]

Hello i have a report which shows jobs data we have inputed! it shows Job id
as a field and if the job was filled it shows the placement ID number (like
below)

jobID company placedID
11111 test 22222
33333 test33
44444 test44 66666

what i want to do is two fold 1) if there is a a value in the placedID field
then the field returns 'Placed' instead of the number (i would imagine
adding an unbound text box and entering a expression)

also i want to 'count' the placedID fields if there is a value in it!

any help will be appreciated thanks

 

[Steve Schapel]

S,

1)
=IIf(IsNull([placedID]),Null,"Placed")

2) In Form Footer...
=Sum(IIf(IsNull([placedID]),0,1))

 

[smason]

excellent work great

thanks for your help

S,

1)
=IIf(IsNull([placedID]),Null,"Placed")

2) In Form Footer...
=Sum(IIf(IsNull([placedID]),0,1))

--
Steve Schapel, Microsoft Access MVP

Hello i have a report which shows jobs data we have inputed! it shows Job id
as a field and if the job was filled it shows the placement ID number (like
below)

jobID company placedID
11111 test 22222
33333 test33
44444 test44 66666

what i want to do is two fold 1) if there is a a value in the placedID field
then the field returns 'Placed' instead of the number (i would imagine
adding an unbound text box and entering a expression)

also i want to 'count' the placedID fields if there is a value in it!

any help will be appreciated thanks