Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Going Crazy; Group headers in report not working

Discussion in 'Information Technology' started by dogmelissa, Jul 28, 2006.

  1. dogmelissa

    dogmelissa
    Expand Collapse
    Guest

    I have a bunch of reports and all of them are working fine except one...

    I'm trying to find jobs by customer's last name. The query uses this as
    search criteria: Like "*" & [What is the last name you are looking for?] &
    "*" under the field of LastNames. When I run the query by itself, with the
    criteria "bailey", I get 3 records, 2 different results: Judy Bailey & Keith
    Bailey.
    Problem is when I run the report for this query, I have it set to Sort by
    LastNames, with a Group Header, and also sort by job#, with no header for
    job#. In design mode, I have a field of LastNames (text box) under the
    LastNames Header. However, when I run this report with the same criteria as
    above, I get all 3 job #s, but only one heading; Keith Bailey. I can't figure
    out what's gone wrong, especially since I have 2 other reports set up to do
    this on different criteria, and they're working great.
    Anyone have any ideas?

    Thanks!
    Melissa
     
  2. Loading...


  3. dogmelissa

    dogmelissa
    Expand Collapse
    Guest

    Correction.... it's not getting confused about the set up.. it's confused
    because the last names of these 2 clients is the same, and it doesn't know
    how to separate them. I have added a FirstNames box to the LastNames header,
    but do I need to make it sort on first names, too, in order to get this to
    work?
    Thanks!
     
  4. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Melissa

    Does your table have a primary key? (It should do!)

    The trick it to add an extra group level - LastName at the top level and
    then your primary key. Then add a group header for the PK level but not for
    LastName. The result is that you sort by LastName (because it's the top
    level) but you also get a new header for each record (because the primary
    key has changed).
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "dogmelissa" <dogmelissa@discussions.microsoft.com> wrote in message
    news:1B85C7D1-7CBF-486A-B12D-2676F355FB7B@microsoft.com...
    > Correction.... it's not getting confused about the set up.. it's confused
    > because the last names of these 2 clients is the same, and it doesn't know
    > how to separate them. I have added a FirstNames box to the LastNames
    > header,
    > but do I need to make it sort on first names, too, in order to get this to
    > work?
    > Thanks!
    >
     
  5. dogmelissa

    dogmelissa
    Expand Collapse
    Guest

    Yes I have a primary key, but this method would result in a complete change
    of the way my report looks. I don't want a new header for each record (some
    reports have 100+ records!). I'm going to play a little bit with sorting by
    first name and see how that works.
    Thanks anyhow,
    Melissa

    "Graham Mandeno" wrote:

    > Hi Melissa
    >
    > Does your table have a primary key? (It should do!)
    >
    > The trick it to add an extra group level - LastName at the top level and
    > then your primary key. Then add a group header for the PK level but not for
    > LastName. The result is that you sort by LastName (because it's the top
    > level) but you also get a new header for each record (because the primary
    > key has changed).
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "dogmelissa" <dogmelissa@discussions.microsoft.com> wrote in message
    > news:1B85C7D1-7CBF-486A-B12D-2676F355FB7B@microsoft.com...
    > > Correction.... it's not getting confused about the set up.. it's confused
    > > because the last names of these 2 clients is the same, and it doesn't know
    > > how to separate them. I have added a FirstNames box to the LastNames
    > > header,
    > > but do I need to make it sort on first names, too, in order to get this to
    > > work?
    > > Thanks!
    > >

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page