Add a new table or new field

L

Linda

Hello,

I have an Employee database. There are about 10 people in the Employee
Table who have their own phone numbers, and fax numbers. The rest of the 80
all have the same phone number. What is the best way to create a report for
these specific people. They are not all in Mgmt., some are educators, some
are specialists, but we want a report with their phone and fax numbers. Do
I make a new table for just office phone and fax numbers that somehow links
to the main table? Also we would like a couple of people on the report
who are in 2 other databases and a couple who are not even in our department
database. Would I make another table that this table could link to for
these people?

Thanks,
Linda
 
T

Tim Ferguson

The rest of the 80
all have the same phone number. What is the best way to create a
report for these specific people.

This sounds like a use for the other paremeter in Nz:

controlsource = Nz([PhoneNumberField],"020 7899 1029")

Just to remind you, the Nz function returns the first value it is passed,
unless that is Null, in which case it returns the second (default) value.
Although the second one is nearly always "" or zero, there are occasions
when you need a proper default.
Also we would like a couple of people on the report
who are in 2 other databases and a couple who are not even
in our department database. Would I make another table
that this table could link to for these people?

Short fix: use a union query to add the extra names. Proper fix: think
properly about the overall design of your database and how you intend to
manage information. Little bits scattered here and there in different files
is no way to keep a company afloat...


B wishes


Tim F
 
L

Linda

Hi Tim,

I have no experience doing this sort of thing. I created a report and
pasted your function there with my field name. My phone number field is
formatted like this...x-xxxx All of the numbers were returned. How do I
weed out this number...1-4222? I want all others to show up? Some of the
other numbers that I want to show up will begin with a 7 or 6 instead of a
1.

Thanks,
Linda




Tim Ferguson said:
The rest of the 80
all have the same phone number. What is the best way to create a
report for these specific people.

This sounds like a use for the other paremeter in Nz:

controlsource = Nz([PhoneNumberField],"020 7899 1029")

Just to remind you, the Nz function returns the first value it is passed,
unless that is Null, in which case it returns the second (default) value.
Although the second one is nearly always "" or zero, there are occasions
when you need a proper default.
Also we would like a couple of people on the report
who are in 2 other databases and a couple who are not even
in our department database. Would I make another table
that this table could link to for these people?

Short fix: use a union query to add the extra names. Proper fix: think
properly about the overall design of your database and how you intend to
manage information. Little bits scattered here and there in different files
is no way to keep a company afloat...


B wishes


Tim F
 
T

Tim Ferguson

I have no experience doing this sort of thing. I created a report and
pasted your function there with my field name. My phone number field
is formatted like this...x-xxxx All of the numbers were returned.
How do I weed out this number...1-4222? I want all others to show up?
Some of the other numbers that I want to show up will begin with a 7
or 6 instead of a 1.

I think I misunderstood your original post. I took it that you had a phone
number field where the huge majority of them were going to be the same, and
you wanted a way to avoid typing in the same number over and over again.

Right: second go!

You want to print the report for all people except those where phonenumber
= "1-4222" -- well the way to do that is to use the Filter property of the
report and set it to what you want

PhoneNumber <> "1-4222"

to include everything except that number, or something like

PhoneNumber NOT LIKE "1*"

to exclude everything beginning with a one, and so on. If you have based
your report on a query rather than the table (which is generally a good
idea), then you can add the same thing in the Criterion part of the query
grid.

Hope that helps

Tim F
 

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

Similar Threads


Top