Re: Reports Not Printing Similar Names

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PeterK (PeterK_at_discussions.microsoft.com)
Date: 12/04/04 

Date: Fri, 3 Dec 2004 23:49:03 -0800

Table 1 = Client Household
Fields = HouseholdID, HouseholdName, FirstName, StreetAddress, Phone, etc

Table 2 = Client History
Fields = HistoryID, HouseholdID (=above field), Details, Notes

Report is based on a query that creates a new field:
Name = [FirstName] & “ ” & [HouseholdName]
All other fields from Table 1 and 2 are included

Desired report layout is:
Header: Name
Section A: contact details
Section B: Client History, sorted by date

Sort and grouping order is:
HouseholdName
FirstName
StreetAddress
Name - Group Header / Footer
Date

Test Data produces correct layout for
Diane Allen
J Allen
But I have two clients named Jessie Allen, distinguished by street address,
and the report only lists one of them

Aha - I have just solved one problem and created another!
One Jessie Allen had no records entered in the history table. When I
created a record for her, the report showed both Jessie Allens.
But - how do you write the report / query to show a client name and contact
details even if no data is yet entered in the History table?

"Duane Hookom" wrote:

> Which section of the report do you expect to see unique values? What are the
> exact sorting and grouping levels?
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "PeterK" <PeterK@discussions.microsoft.com> wrote in message
> news:3FC322D3-F64A-4EFE-A6B9-DD0D78DA4527@microsoft.com...
> >I have exactly the same problem, so if anyone can help me out...
> >
> > "PamelaD" wrote:
> >
> >> I have E. Wood and Elmer Wood in FirstName and LastName Fields. On
> >> Report, I
> >> am sorting on both last name and first name. Only E. Wood prints. What
> >> am I
> >> doing wrong?
>
>
>

Relevant Pages

  • Re: Reports Not Printing Similar Names
    ... > Table 1 = Client Household ... > Report is based on a query that creates a new field: ... Client History, ... > created a record for her, the report showed both Jessie Allens. ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... Client number 004576 ... We got the report to work so that it sorts by Avg # of Cows and all the data ... Dave Hargis, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: Comparison Report based on a query of only calculations.
    ... Dave Hargis, Microsoft Access MVP ... "Amy Schmid" wrote: ... Client number Client Name Avg # of Cows Production Livestock ... And you want them to appear on the report like: ...
    (microsoft.public.access.reports)
  • Re: Its Official: BushCo Lied To Take Us To War (NDC)
    ... issue -- the this report will be cited early and often in response. ... try to rewrite history and whitewash Reagan's repeated lying about his ... censure vote before the election however could, and probably would, be ... him so unpopular in the first place is going to help the Republicans. ...
    (rec.music.gdead)
  • RE: Comparison Report based on a query of only calculations.
    ... "Klatuu" wrote: ... (my brain was wrapped up in a report I am working on at ... Dave Hargis, Microsoft Access MVP ... Client number Client Name Avg # of Cows Production Livestock ...
    (microsoft.public.access.reports)