getting phone numbers across a page

[Gareth]

One table of employees;
one table of numbers;
one table of number types eg land-line, mobile, fax.

I want to print a table with employee name in the left and colums for each type of number associated with each person.

I have a feeling I'm missing something obvious! Anyone able to assist?

 

[Fornatian]

Does your 2nd table, "numbers" have a field where you can assign what type of number it is? if not you are going to have problems extracting the number type.

I assume the 2nd table is linked to the first table in a one-to-many relationship?
If so, add both tables to the query grid and insert the fields from both tables and run the query.

If you base a report on that query using the wizard you will be prompted as to how you want to group the data - if you group the data by employees you can then have a grouped report with sub-levels for the associated numbers.

Out of curiosity, is it likely that each employee with have more than one of each number type? If not then you should integrate the numbers into the employees table and simply designate fields for landline, mobile, fax etc...

HTH

 

[Gareth]

Thanks for your reply, Fornation - 1st chance I've had to respond.

It is something along the lines of your grouping solution that I came to in the end too. This still results in the numbers appearing one above the other with the number type beside as opposed to the other way round. My employer's happy with that - I just fancied being able to do it.

One way I tried was to have one query for each of the number types, then another combining the three. What happened here, though was that the result only listed employees with the three types.

In answer to your questioning my method, I think I'd agree by now that my data structure is unncessarily complex, I just got carried away, celebrating my understanding of how it can be done!

Thanks again

 

[KevinM]

If you want your 'number types' to appear in seperate columns then you will have to create a CROSSTAB query first, and then base your report on this query.

Use the CrossTab Query Wizard to create your query.

HTH