Challenging Database Query

S

SoccerBoy

Ge easy as I am new to FP2003. My database has the following fields: Name,
Age, PhoneType, Num1, Num2, Num3, Email. I only want to display the Age if
the Name equals boy; and display Num1, Num2, Num3 if PhoneType is not equal
to home; and Email if the Email field is not empty. How do I accomplish
this? I am most familiar with the Criteria option from the wizard and not
sure how to combine queries to get the desired result from each record.
Please Help!
 
Top