S
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
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