I have about 4 main tables I am working with. One is a listing of company names (Companies), one is a list of the Category they belong to (Resource), one is phone numbers (Phones), and one is phone type (phonetype). The companies table has all of the information I need to make a report with the exception of the phone numbers. The phones table has the fields phone_id, phonenum, and area code. The phone_id is linked to the id field of the phonetype table. The phone type also has another field called description. Description consist of items like Main, Fax, TTD, and a few others.
I have a query that currently displays the following fields: CompanyName, Address, Contact, Area Code, Phone Number, PhoneType The problem is that if they have multiple phones listed in the Phones table, ie...Main and Fax, the CompanyName and all of the information appears on two lines. One line with the Fax and one with the Main. Is there an expression or something I can place in the query to display the area code and phone number for the Main phone type and then create another expression to display the area code and phone number for the Fax phone type so it is all on one row when the query displays? If I can figure this out I should be able to easily design a report that would display the company name, then the address on the next line, then the Main Phone number, and then the fax number. Then the next company, and so on. Thanks, Dale
