Case Statement Help

[phtmb]

Novice needing help with what I believe should be a case function. Six fields: Photog One, Photog Two, Photog Three, Unit One, Unit Two, Unit Three. If I have a name in Photog One and a name in Photog Two, Unit One should read "A/B" and Unit Two Should Read "B/B". If I have a name in Photog One, Two and Three, Units should read "A/C", "B/C", "C/C". If I only have one photog on the job, Unit one should read "A/A". I've tried working with (not Is Empty) calc but can't make it work. Any suggestions greatly appreciated.

[Chuck]

If I understand you correctly, these should work:

Unit One =

Case(

[Fitch]

Here's a cute way to do it -- define another field, PhotogCount:

Count(Photog One, Photog Two, Photog Three) - 1

Note: the "-1" above is so that we can use the Choose() function below, which looks for 0 as the first result...

Unit One = Case(not IsEmpty(Photo One), "A/" &

Choose(PhotogCount, "A", "B", "C"))

Unit Two = Case(not IsEmpty(Photo Two), "B/" &

Choose(PhotogCount, "A", "B", "C"))

Unit Two = Case(not IsEmpty(Photo Three), "C/" &

Choose(PhotogCount, "A", "B", "C"))

[ February 18, 2002, 05:36 PM: Message edited by: Fitch ]

[phtmb]

Thank you both for great solutions! FileMaker not only is a great program but it attracts the best, most helpful group of people. This formum is a godsend for the learners among us!