Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sortin Grouping off (Access2000-03)

    Table has data

    Office ---------- Loc ---------- ID
    111 ---------- 111 ---------- a
    222 ---------- 222 ---------- b
    333 ---------- 55 ---------- c
    444 ---------- 88 ---------- d
    555 ---------- 44 ---------- e

    So Report is sorted by Office,Location,ID

    Data placed into ID Header.

    If Office and Location has different values - all records are displayed by Office.
    If names of the Office and Location are the same - I see one value 111 followed by 333/55, 444/88 and 555/44.

    So if Office and Location values are the same Report does not group/sort. Why? Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sortin Grouping off (Access2000-03)

    I don't understand your description. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sortin Grouping off (Access2000-03)

    Hans,
    I am running into issues with this database I mean Access2000-2003 I had never seen before.
    My grouping was Office.
    I had Office textbox at PageHEader. It wouldn't work.
    So I got mad and went all the way and kept moving it around....then I had placed it where it was before and it worked!
    Just a time wasting!
    And it is happening a lot. Things I know should work - do not work until 'another day'...
    Should I re-install?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sortin Grouping off (Access2000-03)

    That's impossible for me to say. Sorry.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •