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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top