RE: Should be simple but...

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would confirm the phonetype values and just check your data. The query
looks fine. What section of the report are you displaying the data?
--
Duane Hookom
Microsoft Access MVP


"Aria" wrote:

Hello,
This should be simple but maybe I'm missing something easy. I have multiple
versions of phone directory reports for our school. I am not experiencing
problems with the mobile/cell phone directory nor the reverse directory by
location. So far, it list everyone as it should.

I seem to be having a slight problem with the staff directory. It is sorted
by last name, first name and then phone location. There can be multiple staff
members assigned to a location phone. I have one location that lists 6 staff
members to a phone. No problem here. My problem is the office phone. There
are 3 staff employees assigned to the office phone as well as their direct
line phones. The report list 2 of the staff members for the office phone and
only one for the direct/desk phone. All 3 staff employees should be listed
for the office phone as well as 3 seperate entries for direct lines. Thank
you for any ideas or suggestions.

Here's the SQL:
SELECT tblPhonesEmps.PhoneID, tblPhonesEmps.EmpID, tblEmployees.LastName,
tblEmployees.FirstName, tblPhones.PhoneNumber, tblPhones.PhoneDescription,
tblPhones.PhoneType
FROM tblPhones INNER JOIN (tblEmployees INNER JOIN tblPhonesEmps ON
tblEmployees.EmpID = tblPhonesEmps.EmpID) ON tblPhones.PhoneID =
tblPhonesEmps.PhoneID
WHERE (((tblPhones.PhoneType)=2))
ORDER BY tblEmployees.LastName, tblEmployees.FirstName;

--
Aria W.
.

Relevant Pages

  • Psychiatry was inept, report says
    ... inmates by a patient, one David Denge, at the hospital last month. ... A report released by a probe committee formed to investigate the ... members of staff implicated in the incident.The Minister for Health ...
    (sci.med.psychobiology)
  • RE: Should be simple but...
    ... If this is truly a subform, ... What section of the report am I displaying the data? ... I seem to be having a slight problem with the staff directory. ... My problem is the office phone. ...
    (microsoft.public.access.reports)
  • RE: Should be simple but...
    ... subreport and how is it linked to the main report? ... "Aria" wrote: ... I seem to be having a slight problem with the staff directory. ... My problem is the office phone. ...
    (microsoft.public.access.reports)
  • RE: Should be simple but...
    ... There is a text box for phone number and a subform listing the employees ... What section of the report am I displaying the data? ... I seem to be having a slight problem with the staff directory. ... My problem is the office phone. ...
    (microsoft.public.access.reports)
  • Re: Employee resigned then claimed to be fired
    ... members of staff who witnessed the incident, ... witness statements - one saying that see didn't hear exactly what was ... Stylists generally do try and take those clients with them. ...
    (uk.legal)