Phone List Form

  • Thread starter Thread starter Maggie
  • Start date Start date
M

Maggie

I need to make a company phone list. Of course they are
always in two columns. I make two identical tables, then
make the query by choosing names from A through M from
Table 1, then names from N through Z from Table 2. It
doesn't work, or maybe I'm doing it wrong. Can this be
done, or am I doomed to using Excel and having to have one
column, then moving half the column next to the original
column?
 
Maggie said:
I need to make a company phone list. Of course they are
always in two columns. I make two identical tables, then
make the query by choosing names from A through M from
Table 1, then names from N through Z from Table 2. It
doesn't work, or maybe I'm doing it wrong. Can this be
done, or am I doomed to using Excel and having to have one
column, then moving half the column next to the original
column?
Click to expand...

Maggie,
Why 2 tables?
It's one company phone list, have one table.

Then in a query, to get all names that begin with an entered letter:

Select PhoneTable.*
From PhoneTable
Where EmployeeName Like [Enter Name] & "*"

Or... if you want those only names from A to M or N to Z (or any other
run of names)

WHERE Left([EmployeeName],1) Between [Enter Start Letter] And [Enter End
Letter]

Or... to get all the names, don't use any criteria.

In a report, you would have the [EmployeeName] and [PhoneField] and
[DepartmentField] in the Detail section.

You would then print the detail section in 2 columns:
File + PageSetUp + Columns
Set the Number of Columns to 2

The Column Size depends upon your layout.
Leave the 'Same as Detail' checked if the report width is less than, or
equal to the expected column with.

If the Report width is greater than the column width, uncheck the 'Same
as Detail' box and enter the wanted column width.

Chose
Down then Across
for the Column Layout.

Run the report.
 
You can get the display how you want with two datasheets side-by-side as
subforms in a main form. Then you can set the recordsource for each
datasheet to each table, if you must have two tables. Much better would be
to have one table, and two queries, one pulling the A-M names and the other
the N-Z names. Then you just set the datasource for the subforms to the two
queries.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top